How does one use the loadXML function to pass in a string basically - I have a query which I've set up in my db like the following below and now I want to pass that recordset in - but it doesn't appear to let me do this - my recordset keeps coming up empty
set rsXML = dbObj.GetRecordSet("XML_TEST", param1)
'Load the XML
set xmldoc = Server.CreateObject("Microsoft.XMLDOM")
xmldoc.async = false
xmldoc.loadXML (rsXML)
after this code I'm setting up the xsl (almost the same code as above except I'm calling a file on the server using Server.Mappath - which is on the server) (my xml is in the db) then I'm using a
Response.Write(xmldoc.transformNode(xsl))
to mend the xml and xsl together