Greetings, I have a simple problem, but cf doesn't seem to want to comply.
I have numbers stored in my database, some of which are very large and thus get stored as equations (1.078E+07), so I have to use numberformat() on them to get them to display the original number. My problem is that I need to display the original number in it's original format unchanged. Any combination of masks using numberformat() doesn't do this. I can either have decimal places or not, I can't seem to only display them if they exist. E.G. If I use numberFormat(data , '99999999.99') 2 decimal places will be added to all numbers whether they have any or not. If I use numberFormat(data , '99999999_99') No decimal points are shown whether they exist or not. According to the docs, this should show an optional decimal point though. I have tried all the masks to no avail. I even tried <cfif data contains "."> Display with decimal place <cfelse> Don't </cfif> But that doesn't work either. I don't really want to have to do workarounds like converting numbers to strings, there must be an easy way to do what I want? -- Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232042 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
