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!!!
> > 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:184781 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
