Since I have a working knowledge of XML, the quick and dirty solution
for me is to just iterate through the recordset and, for each record,
write some XML to a string or text stream and then save it as a file
when I've finished all the records. ...kind of like...
'ASSUMING YOU ALREADY CREATED A RECORDSET
strXML = "<?xml version=""1.0"" ?>"
strXML = strXML & "<cars>"
Do While Not objRS.EOF
strXML = strXML & "<model name=""" & objRS("modelname") & """ />"
Loop
strXML = strXML & "</category> "
'THEN WRITE STRXML TO A TEXT FILE WITH A .XML EXTENSION.
There are a lot of snobs who will turn their nose up at this type of
approach and tell you you should use ADO or something to transform the
recordset into XML. But this method is quick and easy, and it's
actually the most flexible method, because you can write the XML any way
you like. You're limited only by the possibilities of VBScript, not
ADO.
- JV
> -----Original Message-----
> From: Brian [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 05, 2005 7:45 PM
> To: [email protected]
> Subject: [ASP] Database to ASP to XML
>
>
>
> Hi,
> I'm wanting to gather info from a database and create a
> downloadable xml file using ASP. This is my first project
> using xml. Could someone tell me where I can find some
> resources or a tutorial on how to accomplish this?
>
> thanks.
>
>
>
>
>
> --------------------------------------------------------------
> -------
> Home : http://groups.yahoo.com/group/active-server-pages
> ---------------------------------------------------------------------
> Post : [email protected]
> Subscribe : [EMAIL PROTECTED]
> Unsubscribe: [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
