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:184563 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
