Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with:

Returning NULL Values From A ColdFusion User Defined Function

By Ben Nadel on
Tags: ColdFusion

For those of you have worked with any of the underlying Java methods in ColdFusion or worked with the installed Java libraries, you probably know that Java returns NULL values a lot of the time. And, furthermore, you'll know that if a NULL value is returned, ColdFusion deals with this event by destroying the variable into which the NULL value is stored. Once you understand this, it makes dealing with Java a lot easier.

Of course, up until now, I have only ever deal with NULL values in terms of Java methods. Well what about in ColdFusion; can I return a NULL value from a ColdFusion user defined function? And if so, does it work in the same way? To test this, I set up a simple ColdFusion user defined function which returns a NULL value using JavaCast():

  • <cffunction
  • name="GetNull"
  • access="public"
  • returntype="any"
  • output="false"
  • hint="Returns a NULL value.">
  •  
  • <!--- Return a Java null. --->
  • <cfreturn JavaCast( "null", 0 ) />
  • </cffunction>

Now, I am gonna see what happens when I store that returned value into a ColdFusion struct:

  • <!--- Create a Data Struct. --->
  • <cfset objData = StructNew() />
  •  
  • <!--- Store NULL value. --->
  • <cfset objData.Null = GetNull() />
  •  
  • <!--- Test for KEY existence. --->
  • #StructKeyExists( objData, "Null" )#

Running the code above, we get the following output:

NO

Cool. It looks like ColdFusion handles NULL values in exactly the same way whether it was returned from Java method or a ColdFusion user defined function. I am not sure if I would ever use this, but, I have to say that I do sort of like the way Java returns NULL values when it ends things like loop conditions. It might be worth looking into making that a ColdFusion standard as well.




Reader Comments

That's "null" btw, not NULL. Java is case sensitive and keywords are all lowercase.

The concept of null in Java is that it is 'nothing'. It's a primitive type that's only equal to itself (unlike SQL) and it's not something you can call methods on or use for much of anything but representing 'nothing'.

In CF however, null is really dangerous. You can't compare it to anything else, you can't pass it to CF functions, you can't assign it to some variables, and all kinds of other problems.

Pretty much all you can do with null in CF is get it to pass to Java methods or check if something is null using isDefined().

As for Java, java doesn't use null for loop ending. There's a method called hasNext() or hasMoreElements() or some such other iterator method that tells you if there is more. the next() or nextElement() methods return the next element. It's just a last resort to return null in the even there's no more left (most methods don't actually do this) and you call one of these methods, and even then that's not always true.

In fact methods like next() on the Iterator interface throw NoSuchElementException exceptions when you ask for another element and there's none left.

Did you mean something else for 'loop conditions' ?

Reply to this Comment

@Elliott,

Sorry, you are correct. I was not clear. I didn't mean "looping" in general. I meant just what you said - that some methods in Java return null when they run out of elements. Take for example the LineNumberReader. A some point, the call to ReadLine() will return null, which will then "delete" the variable into which it is stored; I then have to check for that key existence, etc. I use this most generally in a "looping" context.

So, when I said "looping" I meant that that is the situation in which this mostly comes up; I didn't mean to say that that is how Java performs loops in general. Sorry for the confusion.

Reply to this Comment

You may know this - but I only discovered it a couple of weeks ago...

The same behavior (deleting the variable) is also exhibited iif you have the following within a cffunction:

<cfreturn>

The return type of the function needs to be "Any" (or "Void" - but it it was void, then there would be no need to check it)

Reply to this Comment

Hi Ben!
I have a CF-Java codes (not written by me, I don't speak java) that converts a text feed into a query.
All I need to do is to query this query and use the resultset. Unfortunately this java things create difficulty on my simple query may be it is related to what you wrote in this blog about java returning null instead of empty string(?)

My simple query below threw this error:
query to query run time error:
Comparison exception while executing <>.
Unsupported Type Comparison Exception: The <> operator does not support comparison between the following types:
Left hand side expression type = "DOUBLE".
Right hand side expression type = "STRING".

<cfquery name="test" dbtype="query>
Select SSN, Birthdate from MyQuery
Where SSN <> '' OR
Birthdate <> ''
</cfquery>

Reply to this Comment

@Alec,

What you are running into is one of the many times that ColdFusion query of queries become frustrating. Probably, ColdFusion is either trying to convert SSN numbers OR Birthdays into a numberic value (DOUBLE) such that your string '' is not a valid comparison. Try casting the SSN and bday back to varchar:

<cfquery name="test" dbtype="query>
Select SSN, Birthdate from MyQuery
Where
CAST( SSN AS VARCHAR )<> '' OR
CAST( Birthdate AS VARCHAR ) <> ''
</cfquery>

Reply to this Comment

@Ben
I was just looking for the same but in CFMX 6.1
Have you figured out to pass "null" to a Java Constructor or a Method? in CFMX 6.1

Reply to this Comment

@Khurram,

I haven't been on CFMX in a long time. It looks like javaCast() only added support for NULL values in CF7. Perhaps you can try calling a Java method that returns a NULL value (and pass that to the constructor). Sorry I don't have any better advice.

Reply to this Comment

Post A Comment

You — Get Out Of My Dreams, Get Into My Comments
Live in the Now
Oops!
Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.