- see footer for list info -<
Following up on my own message...
Turns out that coldfusion.sql.QueryTableMetaData implements java.sql.resultSetMetaData, not javax.sql.RowSetMetaData. RowSetMetaData has a setColumnTypeName() method, resultSetMetaData doesn't.
My eyesight must have been blurry yesterday as coldfusion.sql.QueryTableMetaData does have a setColumnTypeNames() method (notice the plural), but not a setColumnTypeName() method. I didn't notice the plural and this is what led to the confusion in the first place - I jumped to the conclusion that coldfusion.sql.QueryTableMetaData implemented javax.sql.RowSetMetaData, because it was the only JDBC interface where I found a setColumnTypeName() method.
I've decided to stick to the QoQ and CAST() "hack" because the setColumnTypeNames() method of coldfusion.sql.QueryTableMetaData is not part of a standard JDBC interface and therefore subject to change in later versions of MM CF and any other CFML implementations like BlueDragon. I still don't like it, I still consider it a messy hack, but I haven't found any other reliable option.
Mark
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
-- CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -< - Forum provided by www.fusetalk.com -< - DHTML Menus provided by www.APYCOM.com -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
