> Thanx Mr.Dave > > > ----- Original Message ----- > From: "Dave Watts" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, October 11, 2001 12:24 PM > Subject: RE: Xml from SQL 2k > > > > > Can any one tell me where can i find an article related to > > > xml with CF The database is sql server 2000.And I want to > > > generate the xml from sql 2000. > > > > We had a CFUG presentation covering some of this, that you might > find > > useful. > > http://www.figleaf.com/figleafhome/cfug/2001/CFUGApr2001/sql2000xml. > zip > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > voice: (202) 797-5496 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Your ad could be here. Monies from ads go to support these lists and > provide more resources for the community. http://www.fusionauthority. > com/ads.cfm
I have been desperately searching for something similar to this. From my Coldfusion page I execute a stored procedure that extracts data from my SQL database into an XML format and returns it to my page. My problem is how do I handle back in CF? When I query my #query.recordcount# I have multiple records. When I do a <CFDump> of the query I can all of the XML data that I want. I would like to be able to loop through the recordset and rebuild all of the individual back into one string ready for XML parsing. When I try to do I notice that Each record has only 1 column with a wierd name like 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'? When I try to output the value of this column using the column name I get an error '"18A1," on line 14, column 23, is not a valid identifer name.'. Does anybody know how I can loop through the results of my query and rebuild my single XML string, this problem is driving me mad!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184779 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
