Merry Meet Troy,
Have you tried aliasing the column name.
IE:
SELECT `column-name` as column_name
FROM foo
WHERE bar = 'bar'
That usually works for me. Just make sure that you use ` (on the same key
as the tilde) and not ' (single quote).
Blessed Be,
--Katrina
-----Original Message-----
From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 6:00 PM
To: CF-Talk
Subject: Varaible Names with "-"
Is there any way to pull out the information about a query column that has a
- in it? The problem is that with SQL Server 2000, when you do a for
xml select statement, the column name that is returned has -s in it.
>From the documentation in SQL Server 2000, I am not seeing a name to rename
that. I am trying to pull out the xml from this query, but in order to do
this, I need to get at the data with a column name that has a - in it. If
anyone has any suggestions, please let me know. Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
