Jochem wrote: <snip> >You always have to check the manual, because even with >operations involving 2 exact numeric values the outcome is >often implementation-defined.
Indeed. I have a client whose in-house service system relies on a rdbms that stores all numeric values to something like 13 decimal places, but displays the value -- even in the db manager -- according to the format mask supplied; so even tho' the field spec is set to a precision of X decimal places the internally-stored value - which is used by the system when doing any further calcs - is actually slightly different. Left to itself you can guess what that will do to multi-stage calcs. I never much appreciated having to deal with this 'feature'. <snip> >Common sense says that any exact numeric value should be OK, >so NUUMERIC, DECIMAL, INTEGER and SMALLINT will work. I agree, but as you say: RTFM. --------------------------------------- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm