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

[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 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 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
(CFQUERY), occupying document position (41:7) to (41:98).



----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.