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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
