I came to a point in my project when I had to query the database using a dynamic column name. It was easy to get the query right:

<cfquery name="myQuery" datasource="myDataSource">
SELECT #dynamic_column_name#
FROM #my_table_name#
</cfquery>

but it was tricky to print out the results of the query. After playing around with # signs and String functions, I searched for the solution online and discovered an evaluate() function:

<cfloop query="getDetails">
<cfoutput>
<field>
#evaluate(column)#
</field>
</cfoutput>
</cfloop>