Check that attributes.rating is in fact a number and not just an empty string "". If you want a 0 when inserting an empty string, use the val() function.
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/12/21 Logan Lynn <ljl...@gmail.com>: > > I've spent the past three hours trying to figure out what in the world is > going wrong. I'm trying to insert a simple Decimal value into a mysql 5 > database when I get the following error: > > "Error casting an object of type java.lang.String to an incompatible type. > This usually indicates a programming error in Java, although it could also > mean you have tried to use a foreign object in a different way than it was > designed." > > This is the value I'm using: > <cfqueryparam value="#attributes.Rating#" CFSQLType="cf_sql_decimal" > scale="2"> > > Any help is greatly appreciated! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
