I personally always use the cfsqltype CF_SQL_Numeric for everything in mySQL, although all of my fields tend to be just plain type int() (id fields are 'unsigned'). Maybe switching to that would help? Also I don't use the maxlength parm. No idea if that's got any bearing on your problem, but its something you can throw against the wall and see what comes back.
As an aside I found yesterday after a typo that mySQL will accept cf_sql_varchar on numeric fields. This one was an int(10) unsigned primary key in a sql update. -------------------------------------------- Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
