Coldfusion cf8 is null

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?

If you know the scope of the variable, i. I would recommend using this approach if you know the scope of the variable. Len trim stringVar is the second check.

First off it trims any leading or trailing empty spaces from the string - this makes sure that any empty variables are not passed along. Then if something is there it will return the length of the string. If its empty len will return a 0. Len will verify the field has length not blank--there are no NULLs in CF and Val will automatically convert the first character in the string into into a number--or return 0 if it cannot. Take note of Peter's comment below; although this is the least verbose answer, Val may fail in certain edge conditions below, ie.

The field is a string but starts with a number, incorrectly converting it to a number, and evaluating to TRUE. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 10 years, 3 months ago. Active 1 year, 9 months ago. Recently they "unbundled" their contract with Verity and as a result left developers with migrating and replacing this search engine with another one.

They recommended developers begin using an Opensource search engine called Solr sounds like "Solar". And they began bundling it with their installers. The only problem is since Solr is not developed internally by the ColdFusion group neither was Verity the documentation on how to implement, maintain and use it is somewhat lacking. Worse, there appears to be some bugs in the integration pieces for starting and stopping the service a provided run control script and the example solr.

Essentially here is how I got it working: 1. Small clarification, null values are converted to an empty string "" in queries. NullyB NullyB 1 1 silver badge 2 2 bronze badges. If the variable is a result from a database query, a null result will become an empty string in CF, then you have to use len.

Scott Jibben Scott Jibben 2, 1 1 gold badge 13 13 silver badges 22 22 bronze badges. While this code snippet might solve the issue and provide some limited, immediate help.

A proper explanation would greatly improve its long-term value by showing why this is a good solution to the problem and would make it more useful to future readers with other, similar questions. Please add some explanation to your answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.