DECIMAL(4,4) is a bit strange - the (4,4) part means your column can store a value with 4 digits, 4 of which are decimal points - effectively means you can only store a range of values between -.9999 and .9999 in your column. the first 4 in (4,4) denotes total number of digits allowed - integers and decimals - not the length of integer part of column value.
Azadi On 28/12/2010 08:46 , Monique Boea wrote: > I have created a table that needed decimal columns. > > Here is my script: > > CREATE TABLE `goals` ( > `enrollments` DECIMAL(4,4) DEFAULT NULL , > `followups` DECIMAL(4,4) DEFAULT NULL , > `outcomes` DECIMAL(4,4) DEFAULT NULL , > `productivityPoints` DECIMAL(4,4) DEFAULT NULL , > `hoursWorked` DECIMAL(4,4) DEFAULT NULL , > `extrabreakACW` DECIMAL(4,4) DEFAULT NULL , > `productiveHours` DECIMAL(4,4) DEFAULT NULL , > `totalCalls` DECIMAL(4,4) DEFAULT NULL , > `callsPerhour` DECIMAL(4,4) DEFAULT NULL , > `datelastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP, > `lastUpdatedBy` varchar(200)); > > > > When I try to insert a record I get the following error: > > 1264: Out of range value adjusted for column 'enrollments' at row 1i've > googled the error and most resources say that the occurs when INSERT query > makes try to insert an empty value into a NOT NULL field, but I know this is > not the case here.Any suggestions?Thanks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
