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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
