Determining if a string is not null/blank and is a number and not 0?

coldfusion coldfusion-8
Reno picture Reno · Oct 13, 2011 · Viewed 21.3k times · Source

I normally don't work in ColdFusion but there's a FTP process at work I have to create a report for with the only option right now being a ColdFusion 8 server. This FTP feed has a few issues (trash too).

So, I make the query and then I need to convert some of the string values during the output to do some math. Before that:

How do I tell if a field in the output loop: is not blank or null, is string that can be converted into a valid number, and is not 0?

Is there a simple way of doing this w/o a lot of if statements?

Thanks!

Answer

Peter Boughton picture Peter Boughton · Oct 13, 2011

So you want to make sure that the variable is numeric but not zero?

Then you want this:

<cfif IsNumeric(MyVar) AND MyVar NEQ 0 >

Related questions

Coldfusion - How to loop through an Array of Structure and print out dynamically all KEY values?

Giving the Array of Structure below: I am able to print out all values from all fields by doing: <cfset ColumnNames = structKeyArray(ApiData[1])> <cfset ColumnLength = ArrayLen(ColumnNames)> <cfloop from="1" to="#ArrayLen(ApiData)#" index="i"> &…

Read More
Picking a ColdFusion MVC Framework

I am taking over a lot of the ColdFusion stuff that is lingering at our shop and they are insistent it stay on ColdFusion and that new projects in this area MUST be done in CF - basically this part …

Read More
How can I clean HTML tags out of a ColdFusion string?

I am looking for a quick way to parse HTML tags out of a ColdFusion string. We are pulling in an RSS feed, that could potentially have anything in it. We are then doing some manipulation of the information and …

Read More