The only way I found to do this is actually get an ADO stream, I wrote an SP that gets the result and stores it into a T-SQL variable.
If you are interested I can post it when I find it..? Taco Fleur > -----Original Message----- > From: Andy McShane [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 November 2004 8:27 PM > To: CF-Talk > Subject: RE: SQL Query using 'FOR XML' & Coldfusion > > > 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:184720 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
