« Return to Thread: Data Truncated Error

Data Truncated Error

by Mike Staver :: Rate this Message:

Reply to Author | View in Thread

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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

 « Return to Thread: Data Truncated Error