http://216.239.57.104/search?q=cache:DCTbFs36U50J:www.houseoffusion.com/cf_lists/index.cfm/method%3Dmessages%26threadid%3D19430%26forumid%3D4+%22for+xml%22+coldfusion+%22rob+rohan%22&hl=en
On Thu, 18 Nov 2004 10:27:05 -0000, Andy McShane <[EMAIL PROTECTED]> wrote: > 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:184796 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
