DEV Community

loading...

Discussion on: ColdFusion Query-of-Query Reserved Words or Bug?

Collapse
gamesover profile image
James Moberg Author

I've encountered issues when continuing to work with a query after using SetColumnNames(). When retrieving the column names using columnlist, getMetaData().getColumnLabels() and getColumnNames(), the getMetaData() function would only return the initial columns names instead of the modified column name.

To work around this, perform a QofQ using an alias. Here's a user-defined function (UDF).
gist.github.com/JamoCA/3bb02cdbdea...