Have you checked the raw result coming back from the DB (i.e. #qPayments.refundamt#)? That might be the difference.
cheers, barenyb On Thu, Feb 19, 2009 at 3:38 AM, shaun mccran <[email protected]> wrote: > > Hi all, > > > > I have a weird issue with some number formatting, or more specifically I > think it is a rounding issue. > > > > I have a cfc result that is being used in a query of queries, and the results > are being output into a table of numeric values, like an invoice. > > > > On my local development environment the figures are displaying correctly > using this code: > > > > #decimalformat(variables.qPayments.refundamt * variables.mult)# > #NumberFormat(variables.qPayments.refundamt, "__.__")# > #LSNumberFormat(variables.qPayments.refundamt * variables.mult, "__.__")# > > > So a value of 24.95 will actually display as 24.95. As soon as I move the > code to our testing server it rounds the numbers out! so the value becomes > 24.00. > > > > Both servers are running cf8. > > > > Anyone got any ideas? > > > > Thanks > > > > Shaun McCran > > E: [email protected] > W: www.mccran.co.uk > > > _________________________________________________________________ > Discover Bird's Eye View now with Multimap from Live Search > http://clk.atdmt.com/UKM/go/111354026/direct/01/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
