Prior to CFMX 7, if I was attempting to put some data into field in my database that was 7 characters long for example, while my data was 8 characters, it would just truncate it and keep running the rest of the query. Since CFMX 7, I get an error which kills the query:

[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

This is a problem for me because I have a massive application that's grown over the years, and in the past it wasn't a definite problem to have some data which is longer than the database field. While I realize I should go back and resize many of the input fields to accept a maximum length, I don't have time to do that at this point.

Is there a way to turn off this warning and have it ignored? I didn't find anything relevant in the CF Administrator, so I'm hoping there is a way to turn it off in the JDBC driver.

---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to