TryCF Gist

trycf-gist-1769673966663-1e823f54-4edd-7567-3bc4-9e9e6c5921bb.cfm

<cfscript>
//query
myQuery = queryNew("id,name,amount,revenue","Integer,Varchar,Integer,Integer",  
[  
    {id=1,name="One",amount=15,revenue=35},  
    {id=2,name=JavaCast("null", ""),amount=18,revenue=41},  
    {id=3,name="Three",amount=32,revenue=73}
]);
writeOutput("The new query is:");
writeDump(myQuery);
</cfscript>

<!--- QoQ --->
<cfquery name="newQoQ" dbtype="query"> 
  select *
  from myQuery
  where name is null
</cfquery>
<cfoutput>The QoQ is:</cfoutput>
<cfdump var="#newQoQ#">