I'm an idiot...there were more arguments in this SQL and THAT was making it do that. Sorry Everyone.
Brian -----Original Message----- From: Yager, Brian T Contractor/Sverdrup [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 12:34 PM To: CF-Talk Subject: OT: updateing a decimal field in an Access DB... I am having problems updatin a field in my database. The field is a number, with field size = Decimal, Format = General Number, and long enough to store my number. Here is my code that isn't working. update tax_tbl set tax_amount = .08 where tax_key = 1; It is putting a -1 as the value. If I change the tax_amount = 0, then it puts 0 in as the value. Can anyone help? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
