This usually happens when the data being inserted into the database is either too long for the field, or of the wrong data type. Is the phone number being inserted correctly into the database?
On Sat, Oct 10, 2009 at 8:28 AM, Dominic Parrillo <[email protected]> wrote: > > Here is scenerio... > > we have a form page you put in customer info... including phone number... > > it turns out if they put in dots like 123.123.1234 we get a truncated area > listed below... note... when you input this on the form... no error occurs... > once the phone is inputed.. there are several additional screens... one page > is credit card... after you give credit card... the FINAL PAGE... displays > the summary of the order.. its that page that throws the error...the error is > below.. > (futher note this didnt happen until i upgraded from CF 7 TO CF8.... > also the order is inserted into database so everything works... it just wont > go to final summary page without trhowing error... > > > This is the error i get... > > > Error Executing Database Query. Data truncation: Data truncated for column > 'd_phone_no' at row 1 > The error occurred on line 391. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4840 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
