JavaScript number format issue

[DKL01]

Hello All,

I'm calling below mentioned server-side JavaScript code multiple times for different dates. When I call the function first time the varibale shows correct value -.89. When I call the function again for next date it shows -.9400000000000001 instead of -.94. If I run the query in SQL Plus it is returning -.94. Any ideas why it is happening like this ? Really appreciate any suggestions.

function DailyReport_Data(rptDate) {

// Code to execute SQL
:
:
// Code to read values
var totOutCashItems;
totOutCashItems = sqlCurs.totOutCashItems;
debug(totOutCashItems);
}

Debug message: -.89
Debug message: -.9400000000000001

Thanks much.

 

[kaht]

Take a look at this link, it explains it all:

http://www.astonisher.com/archives/bugnet/alerts/bugalert9298.html

-kaht

Looking for a puppy?

http://www.silkypups.com

[small](Silky Terriers are hypoallergenic dogs that make great indoor pets due to their lack of shedding and small size)[/small]

 

[DKL01]

Thanks for the response. I code I mentioned is server-side JavaScript not client-side so it's not browser issue. Do you think it's the samething causing this issue ? I'm not doing any calculation. I'm confused.

 

[monksnake]

floats are known to add or subtract a crazy small value like that. The only thing I can say is that you use the .toFixed() method to cut those values off.

Example:

totOutCashItems = parseFloat(sqlCurs.totOutCashItems).toFixed(2);

<.