Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
d473566
Starting Member
23 Posts |
 Posted - 2003-04-08 : 11:23:52
|
| I want to send back the results of my query as XML, so I attach:FOR XML AUTOto my query. My problem is with the column name the server applies to the result set (something like XML_F52E2_B61-18A1-blah...blah...)How do I change that, to something generic like 'results'. The problem I am having with it occurs on the "user" side. They need to take the XML that is created, and then pass it on the flash application, but are unable to access it because the column name is (1) made up of hyphens which create heartache (2) is a randomly created ID (I presume it is, but have not compared letter by letter...)Any insight, as always, is greatly appreciated. |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-04-08 : 13:18:30
|
| Ken Henderson's bookThe Guru's guide to SQL Server Stored Procedures, XML and HTMLwill walk you through this.Sam |
 |
|
|
|
|
|
XML OUTPUT