CF Data Truncated Error - field is phone number & happens when...

[Dominic Parrillo]

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:4839
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

[Maureen-2]

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
<info@...> 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=17837.14401.15

[Dominic Parrillo]

Upon more checking... phone number is being added.. it seems when symbols are addedd to the phone number field we get this error..


Field is varchar - set to 50 characaters...it is saving to database

also - any other resources that i should consider would be great... i am new to world of cf but learning every day... thanks for sharing

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4841
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

[Dominic Parrillo]

a little more info on this issue....

Again - this WAS WORKING fine prioir to upgrading to cf8 -

also - it saves correctly to database... the issue is the final screen that confirms order is where error is thrown but everything work... what prevents a final page from showing that i shoujld be looking at too?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4842
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

[Paul Kukiel-2]

Can you post the code?

On 10/11/09, Dominic Parrillo <info@...> wrote:

>
> a little more info on this issue....
>
> Again - this WAS WORKING fine prioir to upgrading to cf8 -
>
> also - it saves correctly to database... the issue is the final screen that
> confirms order is where error is thrown but everything work... what prevents
> a final page from showing that i shoujld be looking at too?
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4843
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15