Thanks for the quick reply guys.
The data in my recordset contains delimited strings that will have to be split before it is output to the xml file. It looks (to me) like this would be the best way to go about doing it for my situation. Now I just need to freshen up on my xml structure. Thanks again, Brian --- In [email protected], "John Vieth" <[EMAIL PROTECTED]> wrote: > 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/
