This just keeps blowing me away. A simple, simple SQL insert statement keeps throwing an error and I can't figure out why. 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) Everything looks right to me, what in the world could I be missing? Why is it saying that the value is being truncated for the ordernumber column when the value is all numbers definitely is not larger than 75 digits? Thanks for your help, hopefully someone can spot whatever it is that I'm overlooking. -Aaron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
