You are trying to insert a string into a field, with a value longer than the
maximum width of the field. This is the cause of the message. You will
need to limit the maximum length that can be entered by the user to match
the maximum size of the field.
DC
----- Original Message -----
From: Ben Densmore <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 19, 2000 14:06
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=3
> D=
> 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 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> Thanks</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Error Occurred While Processing=20
> Request<BR><BR> Error Diagnostic Information<BR><BR> ODBC =
> Error Code =3D=20
> 22001 (String data right truncation)<BR><BR> [Microsoft][ODBC SQL =
> Server=20
> Driver]String data right truncation<BR><BR> Data Source =3D=20
> "BIOSReference"<BR><BR> SQL =3D "INSERT INTO "europeleads" ( =
> "FirstName" ,=20
> "TodaysDate" ,<BR>"BiosIdString" , "SuperIO" , "CPU" , "CompanyName"
> ,=20
> "CpuSpeed" ,<BR> "PhoneEve" , "Email" , "OEMSignon" , "LastName"
> ,=20
> "BiosInfo" , "BIOS" ,<BR>"BiosDate" , "PhoneDay" , "Chipset" , =
> "Comments" )=20
> VALUES (<BR> ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"<BR><BR> 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> template file=20
> D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM<BR><BR> The =
> specific=20
> sequence of files included or processed=20
> is:<BR> D:\WEBSITE\REGISTER\HTDOCS\LEADS\SUBMIT_BIOSFORM.CFM &
> n=
> bsp; =20
> .<BR><BR> Date/Time: 04/18/00 18:42:41<BR> Browser: =
> Mozilla/4.72 [en]=20
> (Win98; I)<BR> Remote Address: 195.38.97.174<BR> HTTP=20
> Referer:<BR><BR><A=20
> href=3D"http://register.unicore.com:8081/leads/bios_upgrade_form.cfm?uBD
> a=
> te=3D10/22/98&uBType=3DAward&uBID=3D10/22/1998-i440BX-W83977-2A6
> 9=
> KA1AC-GX&uSIO=3DWinbond">http://register.unicore.com:8081/leads/bios
> _=
> upgrade_form.cfm?uBDate=3D10/22/98&uBType=3DAward&uBID=3D10/22/1
> 9=
> 98-i440BX-W83977-2A69KA1AC-GX&uSIO=3DWinbond</A><BR> 977TF=20
> rev 0 found at port 3F0h&uCS=3DIntel 440BX/ZX rev=20
> 3&uOEM=3DGREEN<BR>AGP/PCI/ISA SYSTEM<BR> 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.
