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
