Easy method for setting cfqueryparam null attribute

One function I'm surprised that wasn't built-in to ColdFusion until CF9 is isNull(). Since my company is currently on CF8, I decided to create my own function.  This was useful for me when trying to set the boolean value in cfqueryparam's null attribute.

One solution would be to set a local flag by evaluating len(trim(myvar)), but I thought calling a cfc made more sense, and it is still pretty straightforward.

Feel free to use this code in your non-CF9 applications. I only developed this for use with simple strings, so use with caution. I have now updated the code to handle strings, structs, arrays, and queries. I have not tested nested structures yet. Has anyone used CF9's isNull() function for more complex structures?

	<cfcomponent name="utilities" output="false" hint="I provide various utility functionality">
	<cffunction name="init" access="public" returntype="any" output="false" hint="Initializes the Service">
	<cfreturn this />
	</cffunction>
	<cffunction name="isNullFormat" access="remote" returntype="any" output="false" hint="I return whether something is null">
	<cfargument name="input" type="any" required="true" />
	<cfset var inputdatatype = "">
	<cftry>
	<cfset inputdatatype = arguments.input.GetClass().GetName() />
	<cfif inputdatatype IS "java.lang.String" AND NOT len(trim(arguments.input))>
	<cfreturn true />
	<cfelseif inputdatatype IS "java.lang.String" AND len(trim(arguments.input))>
	<cfreturn false />
	<cfelseif inputdatatype IS "coldfusion.runtime.Struct" AND StructIsEmpty(arguments.input)>
	<cfreturn true />
	<cfelseif inputdatatype IS "coldfusion.runtime.Struct" AND NOT StructIsEmpty(arguments.input)>
	<cfreturn false />
	<cfelseif inputdatatype IS "coldfusion.runtime.Array" AND NOT ArrayLen(arguments.input)>
	<cfreturn true />
	<cfelseif inputdatatype IS "coldfusion.runtime.Array" AND ArrayLen(arguments.input)>
	<cfreturn false />
	<cfelseif inputdatatype IS "coldfusion.sql.QueryTable" AND NOT arguments.input.recordcount>
	<cfreturn true />
	<cfelseif inputdatatype IS "coldfusion.sql.QueryTable" AND arguments.input.recordcount>
	<cfreturn false />
	<cfelse>
	<cfthrow type="customerror" message="Unknown data type." detail="Input: #arguments.input#. Data type received: #inputdatatype#">
	</cfif>
	<cfcatch type="any">
	<!--- fail --->
	</cfcatch>
	</cftry>
	</cffunction>
	</cfcomponent>

view raw cf_IsNullFormat hosted with ❤ by GitHub

ColdFusion query of queries divide by zero not throwing error

Interesting discovery I made today:  If you divide by zero in a ColdFusion query of queries, you don’t get an error.  When you dump the result of the query of queries it shows a special character symbol.  I would have expected to get an error.  Has this been / should this be reported to Adobe as a bug?