Excel and columnnames

[BrainSan]

Hello,

I've been trying to set vars from the result list of an excelsheet.
After making an ODBC connection for the excelsheet and querying the sheet, everything seems fine.
The problem is that some columnnames have dots (.) in it, which CF changes it to number signs (#)
My code is trying to set the result in a struct, but I cannot escape the number signs.

Example: <cfset somevar = somecolumnnamewith## />

I've used double number signs and all kinds of escaping techniques, but all in vain.
Does anyone know what the problem is and have a solution for it?

[paross1]

Since you are doing a query on your spreadsheet, have you tried to alias the column name within the query, then using the alias in CF?

SELECT somecolumnnamewith# AS new_somecolumnname
FROM.......

Phil

[BrainSan]

Thanks for giving me the tip, paross.
I totally forgot about aliasing =)
Altho the correct way was:

SELECT [somecolumnnamewith##] AS new_somecolumnname
FROM .....

For anyone reading this.