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 input
type field).
Hope this helps.
Joel
At 08:43 AM 6/1/00, 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 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.
Joel Richards
Web Developer
Brainstorm Industries
<http://www.brainstormin.net/>[EMAIL PROTECTED]
------------------------------------------------------------------------------
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.