Jump to content
Larry Ullman's Book Forums

Stored Procedure Add_Customer Error Discovered


Recommended Posts

HI Larry and fellow forum members,

 

First of all I love your books, they have taught me so much about website design. Now I have found a pretty big error that I do not know if you have found or not. On the stored procedure add_customers in the second example you have the phone number column set as an INT. After testing my site and wondering where the error was I found out that:

 

2147483647 is the largest int value for mysql.

 

so any phone number you try to insert that is larger than that number comes up as that number (most will be). So I just switched the column and the stored procedure to a BIGINT and the problem is fixed. I just thought if you and your members did not know that yet it would be a good thing to let everyone in on.

Link to comment
Share on other sites

 Share

×
×
  • Create New...