Just a shot in the dark here, did you enable that setting in the cf administrator and have you tried listing the specific fields that are in fact CLOB/BLOB last in your query? I ran into a slightly different issue but somewhat similar a week or so ago and doing this solved my issue.
HTH Bob > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, May 18, 2007 8:07 AM > To: CF-Talk > Subject: query of query - clob error > > I have a nice little query of query going (brilliant little tool query of > queries are). > > Unfortunately, it seems that if my SELECT specifies a field that's a CLOB, > then I > receive an error. Here's the error: > Query Of Queries runtime error. > Unsupported SQL type "java.sql.Types.CLOB". > > Oddly, If I don't specify a list of fields and only do SELECT * then > everything works > a-okay. Whatup with that? Any help? > > > daniel > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
