Oh sorry :) just simple number and decimals:
`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)); here are the values I was inserting enrollments - 33 followup - 25 outcomes - 21.3 and so on. Some were decimals some whole numbers. ----- Original Message ----- From: Justin Scott To: cf-talk Sent: Monday, December 27, 2010 8:33 PM Subject: RE: mySQL Error > I am inserting it on the back end. Ok, what is the value you're trying to insert? The more info you can volunteer up front, the easier it will be to help you. :) -Justin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:340292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
