> 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: [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
To: CFAussie Mailing List <[email protected]>
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:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
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/
