Pardeep,
>
> Hi, does anyone know what might cause this to occur when using CFINSERT?
>
> Error Occurred While Processing Request
>
> Error Diagnostic Information
> ODBC Error Code = 22001 (String data right truncation)
>
> [Microsoft][ODBC SQL Server Driver]String data, right truncation
> The error occurred while processing an element with a general
> identifier of
> (CFINSERT), occupying document position (5:1) to (5:55).
>
This error means that data for one of the fields you are inserting into the
database is larger than the string length set in your database.
eg. your form data is 100 characters, but your database field has a length
of 50 characters.
Regards
Stephen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
