Just a thought about .0000 "precision" is that in many cities the sales tax is a fraction of a cent. So for instance, the sales tax here is .055. As you say, you may not need to account for that now. But will you in the future?
-Kevin > -----Original Message----- > From: Matt Robertson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 2:23 PM > To: CF-Talk > Subject: RE: mySQL equivalent of MS Access "Money" fieldtype? > > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.