I'm not sure what exactly you're asking. 1.078E+07 isn't an equation, just scientific notation. Are you saying your DB is returning numbers of that format, and you want to display them through CF as "normal" decimal numbers? Or something else?
cheers, barneyb On 2/11/06, Snake <[EMAIL PROTECTED]> wrote: > 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 -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232056 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
