Friday, August 9, 2013

ColdFusion QOQ recasting text as date/time

This is the problem that I am currently working on. Any help is appreciated!

The reason for the QOQ is to rename the columns to have proper name value pairs in the view.

I could get the value from the first query successfully by Q_ExcelObject.IID

Cast in the QOQ did not do the trick as mentioned here

But apparently when doing a QOQ the value is cast to a date time even before the value is set with cast in the new query. :(

I found a rename function by Steven Neiland here

Nice work Steve! THANKS! :)



No comments: