It's a decimal type in MySQL and the particular value being processed here is 255900 without and dollar signs, commas, or periods.
Rick -----Original Message----- From: Ken Wexel [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:56 PM To: CF-Talk Subject: Re: What is wrong with this? looks fine...what's the value being returned in your var? On 3/12/07, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Hi, all... > > I'm getting an invalid format mask on this: > > Value="#NumberFormat(Get_Property_Details.Sale_Price, "9999")#" > > Why? > > Thanks, > > Rick > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272409 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
