It's type is "decimal" in MySQL and the particular value being formatted is 255900 in the database...no dollar signs, commas, or periods.
Rick -----Original Message----- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:53 PM To: CF-Talk Subject: Re: What is wrong with this? Rick Faircloth wrote: > I'm getting an invalid format mask on this: > > Value="#NumberFormat(Get_Property_Details.Sale_Price, "9999")#" > Is Get_Property_Details.Sale_Price a number? Or, since it's obviously intended as an amount of money, does the value have something else in it, like a dollar sign? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
