RE: data truncation

Kent Runyan Wed, 19 Apr 2000 09:12:05 -0700
I got the same error when trying to insert more characters than the table
field length in the datasource is set to.


Kent Runyan
Konnections, Inc.


> -----Original Message-----
> From: Ben Densmore [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 19, 2000 8:07 AM
> To: [EMAIL PROTECTED]
> Subject: data truncation
>
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0059_01BFA9E6.FE00C9E0
> Content-Type: text/plain;
>       charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> has anyone run into this problem before? I only get this error message =
> once in a while. some people that submit the form have no problem. about =
> 3 out of 50 people a day get this error.=20
>  Thanks
>
> Error Occurred While Processing Request
>
>  Error Diagnostic Information
>
>  ODBC Error Code =3D 22001 (String data right truncation)
>
>  [Microsoft][ODBC SQL Server Driver]String data right truncation
>
>  Data Source =3D "BIOSReference"
>
>  SQL =3D "INSERT INTO "europeleads" ( "FirstName" , "TodaysDate" ,
> "BiosIdString" , "SuperIO" , "CPU" , "CompanyName" , "CpuSpeed" ,
>  "PhoneEve" , "Email" , "OEMSignon" , "LastName" , "BiosInfo" , "BIOS" ,
> "BiosDate" , "PhoneDay" , "Chipset" , "Comments" ) VALUES (
>  ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
>
>  The error occurred while processing an element with a general
> identifier of (CFINSERT), occupying document position (53:1) to (53:249)
> in the
>  template file D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM
>
>  The specific sequence of files included or processed is:
>  D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM      .
>
>  Date/Time: 04/18/00 18:42:41
>  Browser: Mozilla/4.72 [en] (Win98; I)
>  Remote Address: 195.38.97.174
>  HTTP Referer:
>
> http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBDate=3D10/=
> 22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A69KA1AC-GX&uSIO=3D=
> Winbond
>  977TF rev 0 found at port 3F0h&uCS=3DIntel 440BX/ZX rev 3&uOEM=3DGREEN
> AGP/PCI/ISA SYSTEM
>  Template: D:\WebSite\register\htdocs\leads\submit_biosform.cfm
>
>
>
> Ben Densmore
> Webmaster
> eSupport.com, Inc
> TouchStone Software Corp.
>
>
> ------=_NextPart_000_0059_01BFA9E6.FE00C9E0
> Content-Type: text/html;
>       charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>has anyone&nbsp;run into this problem =
> before? I=20
> only get this error message once in a while. some people that submit the =
> form=20
> have no problem. about 3 out of 50 people a day get this error. =
> </FONT></DIV>
> <DIV><FONT face=3DArial size=3D2>&nbsp;Thanks</FONT></DIV>
> <DIV>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Error Occurred While Processing=20
> Request<BR><BR>&nbsp;Error Diagnostic Information<BR><BR>&nbsp;ODBC =
> Error Code =3D=20
> 22001 (String data right truncation)<BR><BR>&nbsp;[Microsoft][ODBC SQL =
> Server=20
> Driver]String data right truncation<BR><BR>&nbsp;Data Source =3D=20
> "BIOSReference"<BR><BR>&nbsp;SQL =3D "INSERT INTO "europeleads" ( =
> "FirstName" ,=20
> "TodaysDate" ,<BR>"BiosIdString" , "SuperIO" , "CPU" , "CompanyName" ,=20
> "CpuSpeed" ,<BR>&nbsp;"PhoneEve" , "Email" , "OEMSignon" , "LastName" ,=20
> "BiosInfo" , "BIOS" ,<BR>"BiosDate" , "PhoneDay" , "Chipset" , =
> "Comments" )=20
> VALUES (<BR>&nbsp;?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"<BR><BR>&nbsp;The =
> error=20
> occurred while processing an element with a general<BR>identifier of =
> (CFINSERT),=20
> occupying document position (53:1) to (53:249)<BR>in =
> the<BR>&nbsp;template file=20
> D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM<BR><BR>&nbsp;The =
> specific=20
> sequence of files included or processed=20
> is:<BR>&nbsp;D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM&nbsp;&n=
> bsp;&nbsp;&nbsp;&nbsp;=20
> .<BR><BR>&nbsp;Date/Time: 04/18/00 18:42:41<BR>&nbsp;Browser: =
> Mozilla/4.72 [en]=20
> (Win98; I)<BR>&nbsp;Remote Address: 195.38.97.174<BR>&nbsp;HTTP=20
> Referer:<BR><BR><A=20
> href=3D"http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBDa=
> te=3D10/22/98&amp;uBType=3DAward&amp;uBID=3D10/22/1998-i440BX-W83977-2A69=
> KA1AC-GX&amp;uSIO=3DWinbond">http://register.unicore.com:8081/leads/bios_=
> upgrade_form.cfm?uBDate=3D10/22/98&amp;uBType=3DAward&amp;uBID=3D10/22/19=
> 98-i440BX-W83977-2A69KA1AC-GX&amp;uSIO=3DWinbond</A><BR>&nbsp;977TF=20
> rev 0 found at port 3F0h&amp;uCS=3DIntel 440BX/ZX rev=20
> 3&amp;uOEM=3DGREEN<BR>AGP/PCI/ISA SYSTEM<BR>&nbsp;Template:=20
> D:\WebSite\register\htdocs\leads\submit_biosform.cfm<BR><BR><BR></FONT></=
> DIV>
> <DIV><FONT face=3DArial size=3D2>Ben =
> Densmore<BR>Webmaster<BR>eSupport.com,=20
> Inc<BR>TouchStone Software Corp.<BR></FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0059_01BFA9E6.FE00C9E0--
>
> ------------------------------------------------------------------
> ------------
> 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.
RE: data truncation

Reply via email to
