CFLib.org – Common Function Library Project

Description:
Returns True if the value passed to it represents "NULL". Useful for setting NULLs in the NULL attribute of CFPROCPARAM.

Return Values:
Returns a Boolean.

Example:

<cfparam name="DieSizeX" Default = "">
<cfoutput>
Is DieSizeX NULL: #IsNull(DieSizeX)#
</cfoutput>
<p>
Here's what it would look like in an SP:
<p>
cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@pack" value="#Attributes.package_type#" maxlength="25" null="#IsNull(Attributes.package_type)#"

Parameters:

Full UDF Source:

/**
 * Returns True if the value passed to it represents "NULL".
 * 
 * @param val      Value to evaluate for NULL. (Required)
 * @param NullIdentifier      String that represents NULL.  Default is an empty string (""). (Optional)
 * @return Returns a Boolean. 
 * @author Rob Brooks-Bilson (rbils@amkor.com) 
 * @version 1, May 1, 2002 
 */
function IsNull(val){
  var NullIdentifier = "";
  if (ArrayLen(Arguments) gte 2) 
    NullIdentifier = Arguments[2];
  if (val is NullIdentifier) {
    return True;
  }
  else {
    return False;
  }
}