Rick Faircloth wrote: > That got me closer, Jim. > > I tried #NumberFormat(Trim(Get_Property_Details.Sale_Price), > "999999999999999")# > and it did take off the decimal and rounded the number to 255900, however > the 255900 was then preceded by about 4 blank spaces in the form field. >
Yeah...now that I think about it, that is probably one of the main reasons I still have a custom numberformat tag in use at one of my clients (last 4.5 holdout). The last thing it does is trim the output. You could just do it in the query...something like... CAST(Sale_Price AS integer) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:272442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
