Samuel R. Neff wrote >If the goal is to replicate MS Access Money field exactly,
I fortunately don't need calculation precision down that far, so I just stick to dollars and cents. But it brings up a useful point: if you do need to keep track of 10ths, 100ths, 1000ths's of a cent/pence/zlotych etc. you can do it pretty easily by altering your multiplier. something I was thinking of earlier: I don't trap when a user enters '$100.5050', and I should look into the effects of that. so far after about 100k users no one has made that mistake. Doesn't mean they won't, though. --------------------------------------- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail http://foohbar.org - ColdFusion Tools --------------------------------------- ---------- Original Message ---------------------------------- from: "Samuel R. Neff" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Tue, 17 Dec 2002 14:38:50 -0500 >At 10:38 AM 12/17/2002, you wrote: >>(snip) >><cfset form.value=form.value*100> > >If the goal is to replicate MS Access Money field exactly, then you >multiple by 10000 before inserting into db and divide by 10000 when >retrieving. MS Access Money field supports 4 decimal places using fixed >point data type. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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