Aaron Roberson wrote: > 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)
Your datatype is INT, your display mask is 75. You can not store 558972266568040 in an INT field. Use a BIGINT if that is sufficient for current and future needs or a DECIMAL field. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:288079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
