> 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).

This error means exactly what it says on the tin...
"String or binary data would be truncated." - The string would be cropped
before it goes into the table.

Since SQL Server has got error detection for things like this, while Access
doesn't, it's warning you that the string you're trying to enter into the
table is too long...

Either shorten the string, or lengthen the field (varchar's can be upto 4096
characters long)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************


------------------------------------------------------------------------------
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.

Reply via email to