CF8 IsNumeric not working??

[LoanXEngine]

I'd appreciate anyone's help here.

We have a financial app that does lots of calculation type things. To make sure everything is good in the world, we utilize IsNumeric( ) a lot to validate that things are number before processing.

Like so...

<cfif NOT IsNumeric(temp) >
Put up an error message
</cfif>

However, it appears that IsNumeric is not working with CF8. For example, it does not recognize 7.865 or 6.500 as numbers... thus is failing our tests for IsNumeric... when in fact they are numbers.

Anyone else experience this? Is there a quick workaround?

[Newsgroup_User]

in my tests both

<cfset temp = 7.650>

and

<cfset temp = "7.650">

validated correctly as numbers using
<cfif isnumeric(temp)>

not sure why on your system they do not....

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[Newsgroup_User]

I did this:

<cfset temp = 7.650>
<cfoutput>#temp#: #isNumeric(temp)#</cfoutput><br />

<cfset temp = "7.650">
<cfoutput>#temp#: #isNumeric(temp)#</cfoutput><br />

<cfset temp = " 7.650">
<cfoutput>#temp#: #isNumeric(temp)#</cfoutput><br />

<cfset temp = "7.650 ">
<cfoutput>#temp#: #isNumeric(temp)#</cfoutput><br />

And the third one failed. So check for leading spaces in your data.

I think the fourth one should have failed too, really. I'm not sure why CF
takes it upon itself to ignore my trailing spaces.

--
Adam

[Newsgroup_User]

you know, 7.650E-12 is also a number, which it is in scientific
notation, so CF/underlying Java must be doing some format conversions to
determine if passes string is a number or not, 'cos just 7.650E
fails.... but then what sort of conversion will accept and pass/convert
trailing space but not leading space?... smells like something fishy to
me....

<cfset temp = "7.650E-12">
<cfoutput>#temp#: #isNumeric(temp)#</cfoutput><br /><!--- YES --->

<cfset temp = "7.650E">
<cfoutput>#temp#: #isNumeric(temp)#</cfoutput><br /><!--- NO --->
--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[tclaremont]

Use the trim() function on your numbers to reduce the hassle of leading and trailing spaces.

[tomj · Accepted solution]

This was broken in CF8 and will be fixed in a future release.

In the mean time, a Trim() on the data is the best workaround.

Sorry about that.