These settings are found under the advanced setting tab when you register your datasource. Not sure what the default setting is for your buffer, 64k maybe? It's been suggested to me to double that, at any rate mine is set to 128. Hope this helps.
CLOB -- Enable long text retrieval (CLOB). BLOB -- Enable binary large object retrieval (BLOB). Long Text Buffer (chr) Blob Buffer(bytes) Bob > -----Original Message----- > From: daniel kessler [mailto:[EMAIL PROTECTED] > Sent: Friday, May 18, 2007 9:34 AM > To: CF-Talk > Subject: Re: query of query - clob error > > >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. > > Yes, I did try listing the two of them last. I also removed one, just for > testing, and the last field is a CLOB and it still fails. > I can ask to have a setting enabled. What setting would that be? > > Any other thoughts? > > thanks so far. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278646 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
