It's been a long time since I've used Access, but if I remember correctly the currency data type only accepts 2 decimal places. You need to make sure that the data that you are supplying only has 2 decimal places. It is impossible to determine where the extra decimal places are coming from in your example as there is no indication of how that value is being derived. My expectation is that there is some kind of calculation being performed and then assigned back to the form field being applied to the cfinsert.
IMHO, I would not employ the use of a cfinsert tag. Although it makes inserts simpler, it removes the programmers ability to define the field data type expected and perform data type validation using the cfqueryparam as well as allowing me to apply any formatting I desire to the value that is ultimately submitted to the query for insertion. David Phelan -----Original Message----- From: =?ISO-8859-1?Q?Claude_Schn=E9egans [mailto:schneegans@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Sunday, November 03, 2013 9:40 PM To: cf-talk Subject: Problem with data formating in CFINSERT Hi, Weird problem this morning. I have a CFINSERT which fails in an Access database with an error "[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. " First, there is no criteria since it's only an insert. Second, I get the error with a value of 57.49 in a certain field, but entering the valu 57.50 works perfectly! In the error message I can see for this field: param 18) = [type='IN', class='java.math.BigDecimal', value='57.49000000000000198951966012828052043914794921875', sqltype='2'] Could it be that 47 decimal is too much for a "java.math.BigDecimal" or an Access Currency column? And if yes, who is adding all these decimals? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:357023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
