um...somewhere in my head. of course, Dave Watts has a much more
comprehensive list stored in HIS head, but i don't have full time access to
THAT. :)
seriously, no. but you might want to start keeping a (paper/electronic) log
of "things i've seen vs. their causes". a KB of your own, if you
is there a good list of error messages and typical causes?
-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 9:49 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Is there a typical cause for this error message?
yes. it's usually
yes. it's usually seen when you try to insert into a TEXT field in the DB
that is too short for the value being insert.
ex,
inserting the string "Hello world" into a CHAR(4) field.
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Steve Weiner [mailto:[EMAIL
Yeah your field name is too small for the data you want inserted in it. In
other words check the size of your fields or maybe you switched a couple
variables by accident that happened to me one time, spent an hour trying to
figure out why it was giving me this message when all the sizes were
At 10:43 AM 6/1/00 -0400, you wrote:
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.
The error occurred while processing an
the string you are trying to insert/update is larger than the column allows.
-Original Message-
From: Steve Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 10:43 AM
To: '[EMAIL PROTECTED]'
Subject: Is there a typical cause for this error message?
Error Occurred While
You are trying to insert data that has too many characters for the database
field. Increase the allowable size of the field in the Database, or else
limit the number of characters allowed to insert into the field by using
the "Maxlength" attribute in your form field (assuming it is a text
ODBC Error Code = 22001 (String data right truncation)
You may have single quotes around a number or a date.
--
Lee Surma
Public Radio International
[EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
Yes. Your input data is too long for the database column.
You should really validate inputs for length (and type, too).
E.g. if you had a varchar(64) column called Title, do this:
...
cfif Len(Trim(form.title)) GT 64
... output an error msg to the user ...
cfelse
The data that you're trying to input into the field is too long. Either
increase the size of the field or reduce the length of the data.
--K
Katrina Chapman
Consultant
Ameriquest Mortgage
The size of the form field or data field you are inserting is larger than
the size of the field you have created in SQL server.
Aaron
-Original Message-
From: Steve Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 7:43 AM
To: '[EMAIL PROTECTED]'
Subject: Is there a
From: Steve Weiner [mailto:[EMAIL PROTECTED]]
Subject: Is there a typical cause for this error message?
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.
Is the data you are inserting longer than your column width?
Lon Lentz
Applications
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.
The error occurred while processing an element with a general
identifier of
Yes,
A typical cause is the data being inserted too long. Check the length of
the column in the database and your data validation.
HTH
Sean
-Original Message-
From: Steve Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 10:43 AM
To: '[EMAIL PROTECTED]'
Subject: Is
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)
[Microsoft][ODBC SQL Server Driver][SQL Server]String or
binary data would be truncated.
I suspect this means you're sending more data (a longer string, for example)
15 matches
Mail list logo