TryCF Gist

trycf-gist-1770155184812-1e192034-17bf-6cca-c526-82d794ecac78.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#">