Can you remember at all how you handled the column names? i.e. 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'.
-----Original Message----- From: Rob [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 17:42 To: CF-Talk Subject: Re: SQL Query using 'FOR XML' & Coldfusion 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:184712 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
