> I have a table that is out of my control and some of the
> column names have spaces or dashes in them and one is a number.
>
> Querying the table works fine, but when I go to output the
> results of the query CF chokes on these various column names.
> I've tried different formatting functions to present a proper
> variable name to CF, but so far have not had any luck. Does
> somebody know how to format improper column names to that CF
> will output them?
You can alias a column name in your query:
SELECT "Column With Spaces" AS ok_column, ...
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
