How do I handle null values from ColdFusion queries?

coldfusion null cfquery
krishna picture krishna · Oct 29, 2009 · Viewed 12.6k times · Source

If one of the columns in the returned coldfusion query result set has a NULL, how do we check if the value of this column being NULL?

Should we just say <cfif queryname.columnname[i] EQ ''> OR <cfif queryname.columnname[i] eq 'NULL'> ?

Answer

Henry picture Henry · Oct 29, 2009

Null value will only be returned as empty string in a query object.

Related questions

How to check for a null value from the return value in ColdFusion query loop

<cfloop query="GET_ALL_STUDENTS> <cfif #student_id# is NOT NULL> <!--- do something---> </cfif> </cfloop> Above is how I am looping my cf query which returns null value and …

Read More
How to pass "Null" (a real surname!) to a SOAP web service in ActionScript 3

We have an employee whose surname is Null. Our employee lookup application is killed when that last name is used as the search term (which happens to be quite often now). The error received (thanks Fiddler!) is: <soapenv:Fault&…

Read More
How can I create a blank/hardcoded column in a sql query?

I want have a query with a column that is a hardcoded value not from a table, can this be done? I need it basically as a placeholder that I am going to come back to later and fill in. …

Read More