RE: Is there a typical cause for this error message?

2000-06-06 Thread Olive, Christopher M Mr USACHPPM
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

RE: Is there a typical cause for this error message?

2000-06-03 Thread Tom Rainey
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Olive, Christopher M Mr USACHPPM
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Robert Everland
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

Re: Is there a typical cause for this error message?

2000-06-01 Thread Jennifer
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Robert Forsyth
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

Re: Is there a typical cause for this error message?

2000-06-01 Thread Joel Richards
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

Re: Is there a typical cause for this error message?

2000-06-01 Thread Lee Surma
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Chris
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

Re: Is there a typical cause for this error message?

2000-06-01 Thread KChapman
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Aaron Johnson
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Lon Lentz
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Philip Arnold - ASP
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Sean German
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

RE: Is there a typical cause for this error message?

2000-06-01 Thread Dave Watts
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)