I tried DECIMAL(2,1) and still get the same thing. ----- Original Message ----- From: Azadi Saryev To: cf-talk Sent: Monday, December 27, 2010 9:25 PM Subject: Re: mySQL Error
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:340293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
