In the free version of BD, there are no BD-specific DSN settings, since the DSN's need to be set at the OS level.
I realized, however, that I was using cfqueryparam in that query; I always use cfqueryparam for a number of very valid reasons. When I changed that cfqueryparam cfsqltype value from cf_sql_varchar to cf_sql_clob, it worked fine. I had forgotten that cf_sql_clob was one of the valid attribute values. Thanks, Pete On 9/1/07, Paul Hastings <[EMAIL PROTECTED]> wrote: > > Pete Ruckelshaus wrote: > > With a smaller chunk of text, both insert and update queries work just > fine. > > does BD have an "enable CLOB" option and/or "Long Text Buffer (chr)" size > in > it's dsn admin bits? if so turn those on and/or increase the size. > > also wondering about the ODBC driver you're using, been so long i don't > recall > any details but check into that as well. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
