This is a multi-part message in MIME format. --Boundary_(ID_MwJ8uYjdZkUxjqayNHAkDg) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: QUOTED-PRINTABLE I am at my wits end =96 if anyone can help I would greatly appreciate= it. We have been using CFINSERT tags for a long time with CF Server 4.0.1= . today =96 they stopped working and are giving me a String Truncation = Error (see below). Although we have not made database changes and it looks= like the SQL the CFINSERT generates is not picking up the form variables l= ike it should. I have checked the values and there are the same I always us= e for testing. Something in the CF server must have snapped. I experienced this once= before on a different server that we had to install as an emergency server = =96 never did figure it out. We moved to another server/installation and it wa= s fine. I know there are so many variables to a problem like this =96 but if = anyone can direct me in the right direction I would appreciate it. Thanks Here is the CFINSERT: <cfinsert datasource=3D"#application.ourdsn#" tablename=3D"SALESORDER= " dbtype=3D"ODBC" formfields=3D"salesorderno, username, companyno, firs= t, last, shipstreet, shipstreet, shipcity, shipstate, shippostalcode, shipcoun= try, officephone, companyname, buyerpo"> Error msg: Error Diagnostic Information ODBC Error Code =3D 22001 (String data right truncation) [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE= =3D22001 Data Source =3D "CUTTOOLS" SQL =3D "INSERT INTO "SALESORDER" ( "OFFICEPHONE" , "SHIPSTREET" , "U= SERNAME" , "COMPANYNAME" , "LAST" , "SHIPPOSTALCODE" , "SALESORDERNO" , "COMPA= NYNO" , "BUYERPO" , "FIRST" , "SHIPCITY" , "SHIPCOUNTRY" ) VALUES ?,?,?,?,?,?,?,?,?,?,?,?)" The error occurred while processing an element with a general identif= ier of (CFINSERT), occupying document position (10:2) to (10:251) in the tem= plate file C:\InetPub\wwwroot\cutdev\shopping\ctcheckoutcont.cfm The specific sequence of files included or processed is: C:\INETPUB\WWWROOT\CUTDEV\SHOPPING\CTCHECKOUTCONT.CFM . Thanks so much! Elizabeth Marcotte www.cuttools.com --Boundary_(ID_MwJ8uYjdZkUxjqayNHAkDg) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: QUOTED-PRINTABLE <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w= =3D"urn:schemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org= /TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8= 859-1"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 9"> <meta name=3DOriginator content=3D"Microsoft Word 9"> <link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]"> <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> </w:WordDocument> </xml><![endif]--> <style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal =09{mso-style-parent:""; =09margin:0in; =09margin-bottom:.0001pt; =09mso-pagination:widow-orphan; =09font-size:12.0pt; =09font-family:"Times New Roman"; =09mso-fareast-font-family:"Times New Roman";} h4 =09{margin-right:0in; =09mso-margin-top-alt:auto; =09mso-margin-bottom-alt:auto; =09margin-left:0in; =09mso-pagination:widow-orphan; =09mso-outline-level:4; =09font-size:12.0pt; =09font-family:"Times New Roman"; =09font-weight:bold;} p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig =09{margin:0in; =09margin-bottom:.0001pt; =09mso-pagination:widow-orphan; =09font-size:12.0pt; =09font-family:"Times New Roman"; =09mso-fareast-font-family:"Times New Roman";} p =09{margin-right:0in; =09mso-margin-top-alt:auto; =09mso-margin-bottom-alt:auto; =09margin-left:0in; =09mso-pagination:widow-orphan; =09font-size:12.0pt; =09font-family:"Times New Roman"; =09mso-fareast-font-family:"Times New Roman";} code =09{mso-ascii-font-family:"Courier New"; =09mso-fareast-font-family:"Courier New"; =09mso-hansi-font-family:"Courier New"; =09mso-bidi-font-family:"Courier New";} span.EmailStyle15 =09{mso-style-type:personal-compose; =09mso-ansi-font-size:10.0pt; =09mso-ascii-font-family:Arial; =09mso-hansi-font-family:Arial; =09mso-bidi-font-family:Arial; =09color:black;} @page Section1 =09{size:8.5in 11.0in; =09margin:1.0in 1.25in 1.0in 1.25in; =09mso-header-margin:.5in; =09mso-footer-margin:.5in; =09mso-paper-source:0;} div.Section1 =09{page:Section1;} --> </style> </head> <body lang=3DEN-US style=3D'tab-interval:.5in'> <div class=3DSection1> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>I am at my wits end – if anyone can help I would greatly= appreciate it.<span style=3D"mso-spacerun: yes"> </span><o:p></o:p></span>= </font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>We have been using CFINSERT tags for a long time with CF Serve= r 4.0.1.<span style=3D"mso-spacerun: yes"> </span><b><span style= =3D'font-weight: bold'>today</span></b> – they stopped working and are giving me= a String Truncation Error (see below).<span style=3D"mso-spacerun: yes"> </span>Although we have not made database changes and it looks like t= he SQL the CFINSERT generates is not picking up the form variables like it shoul= d.<span style=3D"mso-spacerun: yes"> </span>I have checked the values a= nd there are the same I always use for testing.<o:p></o:p></span></font></span></p= > <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>Something in the CF server must have snapped. I experienced th= is once before on a different server that we had to install as an emergency s= erver – never did figure it out.<span style=3D"mso-spacerun: yes"> </sp= an>We moved to another server/installation and it was fine.<o:p></o:p></span></fo= nt></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>I know there are so many variables to a problem like this R= 11; but if anyone can direct me in the right direction I would appreciate it.<o:= p></o:p></span></font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>Thanks<o:p></o:p></span></font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>Here is the CFINSERT:<o:p></o:p></span></font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><cfinsert datasource=3D"#application.ourdsn#" tablename=3D"SALESORDER" dbtype=3D"ODBC" formfields=3D"salesorderno, username, companyno, first, last, sh= ipstreet, shipstreet, shipcity, shipstate, shippostalcode, shipcountry, officep= hone, companyname, buyerpo"><o:p></o:p></span></font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>Error msg:<o:p></o:p></span></font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <h4><b><font size=3D3 color=3Dblack face=3D"Times New Roman"><span st= yle=3D'font-size: 12.0pt;color:black'>Error Diagnostic Information</span></font><font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></b></h4> <p><font size=3D3 color=3Dblack face=3D"Times New Roman"><span style= =3D'font-size:12.0pt; color:black'>ODBC Error Code =3D 22001 (String data right truncation)= </span></font><font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></p> <p><font size=3D3 color=3Dblack face=3D"Times New Roman"><span style= =3D'font-size:12.0pt; color:black'>[IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=3D22001 </span></font><font color=3Dblack><span style=3D'col= or:black; mso-color-alt:windowtext'><o:p></o:p></span></font></p> <p><font size=3D3 color=3Dblack face=3D"Times New Roman"><span style= =3D'font-size:12.0pt; color:black'>Data Source =3D "CUTTOOLS" </span></font><font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></p> <p><font size=3D3 color=3Dblack face=3D"Times New Roman"><span style= =3D'font-size:12.0pt; color:black'>SQL =3D "INSERT INTO "SALESORDER" ( "OFFICEPHONE" , "SHIPSTREET" , "USERNAME&quo= t; , "COMPANYNAME" , "LAST" , "SHIPPOSTALCODE&quo= t; , "SALESORDERNO" , "COMPANYNO" , "BUYERPO"= ; , "FIRST" , "SHIPCITY" , "SHIPCOUNTRY" ) = VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?)" </span></font><font color=3Dblack><spa= n style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></fo= nt></p> <p><font size=3D3 color=3Dblack face=3D"Times New Roman"><span style= =3D'font-size:12.0pt; color:black'>The error occurred while processing an element with a ge= neral identifier of (CFINSERT), occupying document position (10:2) to (10:2= 51) in the template file C:\InetPub\wwwroot\cutdev\shopping\ctcheckoutcont.cfm <= /span></font><font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></p> <p><font size=3D3 color=3Dblack face=3D"Times New Roman"><span style= =3D'font-size:12.0pt; color:black'>The specific sequence of files included or processed is:= </span></font><font size=3D2 color=3Dblack face=3D"Courier New"><span style=3D'font-size:= 10.0pt;font-family: "Courier New";mso-fareast-font-family:"Courier New";color:black'><br> <code>C:\INETPUB\WWWROOT\CUTDEV\SHOPPING\CTCHECKOUTCONT.CFM .</code></span></font><code><font size=3D2 c= olor=3Dblack face=3D"Courier New"><span style=3D'font-size:10.0pt;font-family:"Cou= rier New"; color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></code= ></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'>Thanks so much!<o:p></o:p></span></font></span></p> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 color= =3Dblack face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0p= t;font-family: Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></= font></span></p> <p class=3DMsoAutoSig><!--[if supportFields]><font color=3Dblack><spa= n=20 style=3D'color:black'><span style=3D'mso-element:field-begin'></span>= <span=20 style=3D"mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail= =20 Signature" <span style=3D'mso-element:field-separator'></span></= span></font><![endif]--><font color=3Dblack><span style=3D'color:black'>Elizabeth Marcotte</span></= font><font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></p> <p class=3DMsoAutoSig><font size=3D3 color=3Dblack face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:black'>www.cuttools.com</span></font>= <font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></p> <p class=3DMsoAutoSig><font size=3D3 color=3Dblack face=3D"Times New = Roman"><span style=3D'font-size:12.0pt;color:black'><![if !supportEmptyParas]>&nbs= p;<![endif]></span></font><font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></p> <p class=3DMsoNormal><!--[if supportFields]><font color=3Dblack><span= =20 style=3D'color:black'><span style=3D'mso-element:field-end'></span></= span></font><![endif]--><font color=3Dblack><span style=3D'color:black'><![if !supportEmptyParas]>&= nbsp;<![endif]></span></font><font color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o= :p></o:p></span></font></p> </div> </body> </html> --Boundary_(ID_MwJ8uYjdZkUxjqayNHAkDg)-- ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ 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.
