This probably isn't the answer you're looking for, but you should rename the column.
That's just plain bad database design to begin with. And there's no need to add on
another layer of unnecessary programming when all you've gotta do is rename the field.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 10:00 AM
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
