Correct. The original query will need to use to_char() on the clob column to get a char type for QoQ to work.
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/7/30 Dave Watts <[email protected]>: > >> When I run Query of Queries on that date the CLOB colums cause this >> error: >> >> Query Of Queries runtime error. >> Unsupported SQL type "java.sql.Types.CLOB". >> >> I checked the CF Adminstrator (CF7), and I do have CLOB checked. > > I don't think query of queries supports CLOB fields. Enabling CLOB > fields for a datasource only affects that datasource. Query of queries > is something else entirely. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
