dmccabe Posted April 1, 2008 Share Posted April 1, 2008 I have 4 fields in a database which are set as type "DECIMAL(4,2)" These are to hold montery values eg: 99.00 and distance in miles eg: 59.5 This works until I put in a 3 or 4 digit number before the decimal place eg: 1000.26 At which point I get this error: "Error: Out of range value adjusted for column 'delhours' at row 1" Anyone give me any clues why? Link to comment https://forums.phpfreaks.com/topic/98963-error-out-of-range-value-adjusted-for-column-delhours-at-row-1/ Share on other sites More sharing options...
paul2463 Posted April 1, 2008 Share Posted April 1, 2008 yes I can because the decimal number 1000.26 is actually a "DECIMAL(6,2)" the decimal format requires two arguments, the first is the maximum number of total digits allowed and the second is the maximum number of digits after the decimal point hope that helps Link to comment https://forums.phpfreaks.com/topic/98963-error-out-of-range-value-adjusted-for-column-delhours-at-row-1/#findComment-506390 Share on other sites More sharing options...
dmccabe Posted April 1, 2008 Author Share Posted April 1, 2008 Superb, thanks Paul! :0 Link to comment https://forums.phpfreaks.com/topic/98963-error-out-of-range-value-adjusted-for-column-delhours-at-row-1/#findComment-506401 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.