Yes, you have to loop over the query columns and build a new string with the columns data.
The way you go about it is pretty wacky and I forget the syntax, but I (and others) have posted how to do it to the list at one point so it should be in the archive (it was like a year ago though) On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane <[EMAIL PROTECTED]> wrote: > Hi all. I am trying to utilise the SQL2000 'FOR XML' functionality to return > the results of a stored procedure, called from Coldfusion using > 'CFStoredProc', as an XML string to my Coldfusion app. I am having a few > problems; > > When I run the query in the SQL query window the results are exactly as I > want, when I then call the stored procedure from Coldfusion app I get a > recordset with multiple rows instead of one record containing a string and > when I look at the 'ColumnList' property of the query I have mulitple columns > with a naming convention as 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > Has anybody managed to use this SQL 'FOR XML' functionality in a Coldfusion > app before? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:184626 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
