Damian Also, in addition to the FOR XML syntax, alternatively you can try using the ADODB.Stream to Save a recordset in XML format as well.
To convert a Query to XML, you may need to check Siteobjects.com http://www.siteobjects.com/pages/soxmloverview.cfm ) . You can use the SOXML custom tag to convery a Query to XML. Thanks and kind regards, Yog ----- Original Message ----- From: "Brian LeGros" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 28, 2002 9:47 PM Subject: RE: [cf-xml] creating xml documents from queries > Damian, > > If you are interested in combining SQL and XML you will need a DB server > such as MS SQL Server 2000 or Oracle 9i. These DB server offer support > for recordsets to be returned in XML. Both also support methods of > using XML docs to operate upon relations in a DB. I am more familiar > with SQL Server 2000, so I would recommend you look into using FOR XML > statement with stored procedures and updategrams. Documentation on both > of these topics can be found on MSDN. Below are the URL's for these > topics in MSDN. Hope this helps. > > http://www.microsoft.com/sql/techinfo/xml/default.asp > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpr > o01/html/sql01c5.asp > > Brian LeGros > Web Applications Manager > Foreign Currency Exchange Corporation > Information Technology > Email: [EMAIL PROTECTED] > Phone: 954 - 749 - 0522 > Fax: 800 - 323 - 4558 > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Damian Perring > Sent: Saturday, January 26, 2002 9:46 AM > To: [EMAIL PROTECTED] > Subject: [cf-xml] creating xml documents from queries > > > Hi, > > I am currently creating a CF application and would like to create XML > documents from SQL query's (The document would have to be created using > a > number of query's nested in loops). I am also seeking to read xml > documents > that will be inserted into a number of tables in the database. > > Could anyone suggest a site that explains this procedure or could anyone > > could explain how this is done. > As you can tell I am new to XML and would appreciate any help given > Kind Regards > Damian > > > _________________________________________________________________ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > > -----------------------+ > cf-xml mailing list > list: [EMAIL PROTECTED] > admin: [EMAIL PROTECTED] > home: http://torchbox.com/xml > > > -----------------------+ > cf-xml mailing list > list: [EMAIL PROTECTED] > admin: [EMAIL PROTECTED] > home: http://torchbox.com/xml > -----------------------+ cf-xml mailing list list: [EMAIL PROTECTED] admin: [EMAIL PROTECTED] home: http://torchbox.com/xml
