Output 2 word columns

I am in the process of converting a classic ASP app into CF 9. On the backend, there are many large, complicated stored procs that are too complicated to edit in the little time that I have to complete this project.

One issue I ran into recently was creating reports in excel. The ASP app calls a stored proc which retrieves the columns headers as 2 words i.e. First Name, Last Name. This works properly in ASP but CF does not like two-word values in the output.

So this: #myquery.first name# does now work.

Here is how to solve this issue:

#myquery["First Name"][myquery.currentRow]#

Enjoy!