> You could just do it in the query...something like... > CAST(Sale_Price AS integer)
That would probably be the easiest solution... Rick -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 6:04 PM To: CF-Talk Subject: Re: What is wrong with this? 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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
