SQL column names with spaces

[gareth7]

Is there any way to use a column name with spaces in it in cfoutput?

An example sql statment would be:

SELECT [first name]
FROM myTable

I then want to output the values using something like #myQuery.[first name]# but cold fusion isn't accepting this.

I know you can use column aliases, but I'm working on a table with 70 columns and I'd rather do a SELECT * than have to specifiy an alias in every query.

 

[csteinhilber]

I'm pretty sure ColdFusion (or, rather, the database driver) automatically converts spaces in column names to underscores... so you should be able to access it via

#myQuery.first_name#

-Carl