How's this for inelegance?
Do your "select *" query, and then do a new query using an alias: "select
#test.columnlist# as goodname"
-David
On Friday, March 02, 2001 8:40 AM, Michel Vuijlsteke [SMTP:[EMAIL PROTECTED]]
wrote:
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
