Yeah, I just kept bringing the range up on that column because even when I had it at 11 or 25 I kept getting the same data truncated error. I went ahead and changed it to varchar(75) to test it.
-Aaron On 8/30/07, Nick de Voil <[EMAIL PROTECTED]> wrote: > > Aaron > > > Here is the error message: > > Query Error: Data truncation: Out of range value adjusted for column > > 'ordernumber' at row 1 > > > > Here is the SQL statement: > > INSERT INTO orders(ordernumber, tax, shipping, total) > > VALUES(558972266568040,0.0,4.75,24.7) > > > > In my database (MySQL 5) I have the following fields in my orders table: > > id (int 11) > > ordernumber (int 75) > > tax (double) > > shipping (double) > > total (double) > > I'm surprise MySQL let you define a column as "int 75". No normal > computer can store an integer with 75 significant digits. You might have > meant to use DECIMAL - but actually I think a character type would > probably be more appropriate. > > Nick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4