luckily this is just a once and done site so i wont have to worry about changing the db, well not until they start coughing up some more cash:)
Dave ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 14, 2003 5:30 AM Subject: Re: best way to enter currency format > Paul Hastings wrote: > >>(say user is bidding $1,000.00) > >>$1,000.00 > >>$1,000 > >>$1000 > >>1,000.00 > >>1,000 > >>1000 > > > > > > use currency datatype on the backend. > > I would have said "Don't use currency on the backend" because it is not > an official datatype, but since you are using Access the correct > alternative, using NUMERIC, is not available. But make very sure your > database driver supports it correctly, because I have read about > problems with money datatypes. And add it to your worry list when you > need to switch to a different database. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
