In a message after the one you sent below, Stephen Moretti commented: "INT is INTEGER which means that there's no decimal places.... Not much good for real money that I'm afraid."
If INT won't display decimals, how do you get around that in CF for monetary values that aren't zero to the right of the decimal? Rick -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 3:17 AM To: CF-Talk Subject: RE: mySQL equivalent of MS Access "Money" fieldtype? I use INT (unsigned) for ALL numerica vals and remove all other parms in the field spec. This results in INT(10) unsigned. Then I use CF to format the value according to whatever display rules I want the output to follow. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 7:44 PM To: CF-Talk Subject: mySQL equivalent of MS Access "Money" fieldtype? Hi, all. What's the best mySQL fieldtype to use for money? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm