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