>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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278592 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

