Problem creating XML file

webmasterbeta

New Member
hello,i'm trying to generate an XML file from the recordsets of tablefor example:OpenCOnnectionset rsTitles = Server.CreateObject("ADODB.Recordset")rsTitles.open "Select * from T_sample", connStrSet strmSaveXML = Server.CreateObject("ADODB.Stream")rsTitles.Save "C:\data\myfile.xml", adPersistXMLszXML = strmSaveXML.readTextset rsTitles = nothingset strmSaveXML = nothingresponse.write(szXML)it generates teh file, but it seems to be in binary codeit suppose to save in my file, an xml file containing my records.I'm using ADO 2.5suggestions? samples are welcome?regards,Giovanna
 
Back
Top