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
