Tag: cfml

How to mimic sql statement logic in cfml / coldfusion?

I Am coming to a problem where I am trying to convert my sql statement to do the same logic in cfml (cfscript>) so, I am trying to mimic this sql statement to display the results inside my cfscript. can somebody help me solve this issue? thanks for the help. SQL: Answer @Scott, I am assuming that: Each row from

Query null values

cfml cfquery coldfusion null sql

I have the column deletedTime in my instances table. Now I want to check in ColdFusion if the value is null. There is only one record to be printed out with the query. IsNull(test) is returning the …