Is it possible to use the new XML output in SQL Server 2000 in ColdFusion
with thing like this:
<cfquery name="test" datasource="pubs">
SELECT * FROM authors FOR XML auto
</cfquery>
<cfoutput query="test">
#something#
</cfoutput>
where "something" is the name of the "field" SQL server returns the XML in.
There's always just one field, and you can obviously get its name with
#test.columnlist#, but the problem is that this "field" has a name with
dashes in it (e.g. XML_F52E2B61-18A1-11D1-B105-00805F49916B), and that CF
chokes on the variable name.
Any ideas anyone?
Michel Vuijlsteke
NEtpoint
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists