Persisting from ADO to XML in DOM

wxdqz

New Member
My goal is to show the xml tree in the page. however when the following coderuns nothing is displayed on the page. I'm trying to save the recordsetinto the dom document and then display it again through the "response.writexmlDoc.text"Any suggestions on why this isn't working?Thanks,Mikeconst adPersistXML = 1Set xDOM = Server.CreateObject("Msxml.DOMDocument")Set xmlDoc = CreateObject("Microsoft.XMLDOM")Set dbServicio= Server.CreateObject("ADODB.Connection")dbServicio.Open Application("DBServicio_ConnectionString")Set rs = CreateObject("ADODB.Recordset")rs.Open "select * from SYS_PaginasCampos", dbServicioxDOM.async = falsers.Save xDOM, adPersistXMLxmlDoc.load(xDOM)Response.Write xmlDoc.text
 
Back
Top