Andy6666uk
Programmer
I want to save an XML file made from a recordset.
The code below makes a text file but the format is anything but XML, it comes out looking like a mess.
Any ideas what I'm doing wrong?
<%
Set rsPerson = Server.CreateObject("ADODB.Recordset"
rsPerson.Open "Person", db
Dim SourceFile, strSource
SourceFile = "textfiles/text001.xml"
strSource = Server.MapPath(SourceFile)
rsPerson.Save strSource, adPersistXML
rsPerson.Close
%>
thanks
The code below makes a text file but the format is anything but XML, it comes out looking like a mess.
Any ideas what I'm doing wrong?
<%
Set rsPerson = Server.CreateObject("ADODB.Recordset"
rsPerson.Open "Person", db
Dim SourceFile, strSource
SourceFile = "textfiles/text001.xml"
strSource = Server.MapPath(SourceFile)
rsPerson.Save strSource, adPersistXML
rsPerson.Close
%>
thanks