Re: BlueDragon 7 problem with Text datatype
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
BlueDragon 7 problem with Text datatype
I have a CFMX7 application that I am trying to get to work with BlueDragon Server 7 (the free edition for now). Server is running Windows 2003 Server with IIS. Database is MS SQL Server 2005 Standard Edition. With the exception of one very important issue, everything's working pretty well. The thing that isn't working is sort of a show-stopper. Part of the app is a Content Management System for creating site pages. The corresponding field in the database is of type text, which should (theoretically) handle the 12k worth of text without a problem. However, with BD7 using both reguloar as well as SQL Native drivers, I get the following error on both insert and update queries: General SQL Error; Database reported: [Microsoft][ODBC SQL Server Driver]String data, right truncation With a smaller chunk of text, both insert and update queries work just fine. However, the same code running on CFMX7 against a SQL Server 2005 database allows the full chunk of text to be inserted without a problem. Has anyone else run into this issue, and if so, is there a workaround? I would love to use BD7 for this project (I'm a high school teacher and it's the web site for my web design and computer science classes), but this error would really be a show-stopper since I need to be able to add my lesson plans to the web site via this interface, and my lesson materials can be pretty lengthy. Thanks, Pete ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: BlueDragon 7 problem with Text datatype
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:287626 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4