Title: qUeryHelper Plugin
Thread: qUeryHelper Plugin
Forum: Enhancements
Conference: ColdBox
User: refriedchicken Can I suggest:
[code]
<cffunction name="filterNull" access="public"
returntype="query" hint="Filters a query by NULL" output="false">
<!---
************************************************************* --->
<cfargument name="qry" type="query" required="yes" hint="Query to filter">
<cfargument name="field" type="string" required="yes" hint="Field to filter
on">
<!--- ************************************************************* --->
<cfset var qryNew = QueryNew("")>
<cfquery name="qryNew" dbtype="query">
SELECT *
FROM arguments.qry
WHERE #trim(arguments.field)# IS NULL
</cfquery>
<cfreturn qryNew>
</cffunction>
[/code]
I added it to mine
and it has enabled me to filter when a column has a null value.
http://forums.coldboxframework.com/index.cfm?event=ehMessages.dspMessages&threadid=AAC4B7D7-FF65-CEF6-651B7C672585EB48