TryCF Gist

trycf-gist-1769673023095-8e1885f8-7106-2582-d67e-f843c7d986a5.cfm

<cfscript>
writeOutput("The server is:");
writeDump(server.coldfusion);

//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#">