Custom number format function does not work to return 0's as decimals

Question

HiMy custom number formatting function does not work. It was working fine when the site had a standard client server architecture. However, when we changed to using REST API with javascript and HTML5 the function works for most parts except cases when I need it to display 0's for decimals.Basically, the function takes arguments a number and number of decimals and, returns the number rounded to the number of decimals passed. Below, I stripped the function to bare minimum, same as I was testing. When I pass 55.00089 and 3, the function returns 55.001.When I pass 55 or 55.000000 or 55.0000089 and 3, the function returns 55. And, I need 55.000.I tried both to returntype "string" and "numeric", various masks like _.999, _.000, _.___.I tried straight return NumberFormat(in_decCost,"_.000").Nothing works.I am using CF10 on Windows Server 2008.Any help greatly appreciated.Thanks,Gena

tribule · Accepted Answer

How the works? I am not sure how to describe.

I tried to display a NumberFormat(55,"0.00")

This is how it looks in browser as json formatted raw data. Not bumped around in structures and arrays inside the app. This is a top structure element that is set on 5th line of the REST component.

"testnumber": 55,

"success": true

And here is the kicker, I tried the same in Chrome REST Console this is how it looks.

"testnumber": 55.000,
"success": true

Can someone explain this? Why in Chrome REST Console the data looks as expected with 0's but, in browser window as a json formatted raw data 0's are truncated.

Can you explain how the data gets into the browser as a JSON formatted string?

genadi_mak · Answer

UPDATE: I called this very function from regular cfm page like that

APPLICATION.cfc.calccostcoverage.dispCostPeriod(55,3)

And, it works as expected and returns 55.000.

Just wondering if it is something to do with how REST API returning values.

Custom number format function does not work to return 0's as decimals

Hi

My custom number formatting function does not work. It was working fine when the site had a standard client server architecture. However, when we changed to using REST API with javascript and HTML5 the function works for most parts except cases when I need it to display 0's for decimals.

Basically, the function takes arguments a number and number of decimals and, returns the number rounded to the number of decimals passed. Below, I stripped the function to bare minimum, same as I was testing.

<cffunction name="dispCostPeriod" access="remote" returntype="string" output="false" hint="Displays costs for a given period to user">

<cfargument name="in_decCost" type="numeric" required="yes" />

<cfargument name="in_iRound" type="numeric" required="yes" />

<cfset decRoundedNum = NumberFormat(in_decCost, "_." & RepeatString("9",in_iRound))>

<cfreturn decRoundedNum />

</cffunction>

When I pass 55.00089 and 3, the function returns 55.001.

When I pass 55 or 55.000000 or 55.0000089 and 3, the function returns 55. And, I need 55.000.

I tried both to returntype "string" and "numeric", various masks like _.999, _.000, _.___.

I tried straight return NumberFormat(in_decCost,"_.000").

Nothing works.

I am using CF10 on Windows Server 2008.

Any help greatly appreciated.

Thanks,

Gena

2 replies

Hi