Your variable is bigger than the column in the database, eg. variable is 50
chars, column is 10 chars
HTH
Bjorn Jensen
-----Original Message-----
From: Pardeep Singh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 3:11 PM
To: CF-Talk
Subject: Re: Insert error (String data right truncation)
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).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
