« Return to Thread: Data Truncated Error
Re: Data Truncated Error
by Mike Staver
::
Rate this Message:
> However, I have never seen a DB connection (prior to ColdFusion 7 or
> otherwise) not give this error - it is database specific not
> ColdFusion.
That's where I disagree with you - I can take this exact same code, run
it under CF5 or CF 6.1 against the same SQL Server 2000 database and it
works. Do it under CFMX 7, and I get this error. In my opinion, it is
JDBC Driver related. I'm using CFMX 7 on a CentOS 4.1 linux server, and
I've always run my CF installs on different linux distros. I'm hoping
to find a way to make JDBC ingore this and keep on working with the query.
Robertson-Ravo, Neil (RX) wrote:
> cftry / cfcatch in your code to trap them.
>
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
> Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540. It contains information which is
> confidential and may also be privileged. It is for the exclusive use of the
> intended recipient(s). If you are not the intended recipient(s) please note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful. If you have
> received this communication in error please return it to the sender or call
> our switchboard on +44 (0) 20 89107910. The opinions expressed within this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -----Original Message-----
> From: bounce-cfaussie-21631@...
> <bounce-cfaussie-21631@...>
> To: CFAussie Mailing List <cfaussie@...>
> Sent: Wed Jan 18 21:01:48 2006
> Subject: [cfaussie] Data Truncated Error
>
> 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:
> Neil.Robertson-Ravo@...
> To unsubscribe send a blank email to
> leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
> This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
> Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540. It contains information which is
> confidential and may also be privileged. It is for the exclusive use of the
> intended recipient(s). If you are not the intended recipient(s) please note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful. If you have
> received this communication in error please return it to the sender or call
> our switchboard on +44 (0) 20 89107910. The opinions expressed within this
> communication are not necessarily those expressed by Reed Exhibitions.
> Visit our website at http://www.reedexpo.com
>
> ---
> You are currently subscribed to cfaussie as: staver@...
> To unsubscribe send a blank email to leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
---
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/
> otherwise) not give this error - it is database specific not
> ColdFusion.
That's where I disagree with you - I can take this exact same code, run
it under CF5 or CF 6.1 against the same SQL Server 2000 database and it
works. Do it under CFMX 7, and I get this error. In my opinion, it is
JDBC Driver related. I'm using CFMX 7 on a CentOS 4.1 linux server, and
I've always run my CF installs on different linux distros. I'm hoping
to find a way to make JDBC ingore this and keep on working with the query.
Robertson-Ravo, Neil (RX) wrote:
> cftry / cfcatch in your code to trap them.
>
>
>
>
>
>
>
> "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
> Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540. It contains information which is
> confidential and may also be privileged. It is for the exclusive use of the
> intended recipient(s). If you are not the intended recipient(s) please note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful. If you have
> received this communication in error please return it to the sender or call
> our switchboard on +44 (0) 20 89107910. The opinions expressed within this
> communication are not necessarily those expressed by Reed Exhibitions."
> Visit our website at http://www.reedexpo.com
>
> -----Original Message-----
> From: bounce-cfaussie-21631@...
> <bounce-cfaussie-21631@...>
> To: CFAussie Mailing List <cfaussie@...>
> Sent: Wed Jan 18 21:01:48 2006
> Subject: [cfaussie] Data Truncated Error
>
> 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:
> Neil.Robertson-Ravo@...
> To unsubscribe send a blank email to
> leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
> This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
> Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
> Registered in England, Number 678540. It contains information which is
> confidential and may also be privileged. It is for the exclusive use of the
> intended recipient(s). If you are not the intended recipient(s) please note
> that any form of distribution, copying or use of this communication or the
> information in it is strictly prohibited and may be unlawful. If you have
> received this communication in error please return it to the sender or call
> our switchboard on +44 (0) 20 89107910. The opinions expressed within this
> communication are not necessarily those expressed by Reed Exhibitions.
> Visit our website at http://www.reedexpo.com
>
> ---
> You are currently subscribed to cfaussie as: staver@...
> To unsubscribe send a blank email to leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
---
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
| Free embeddable forum powered by Nabble | Forum Help |
