Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1702028917144-e60e36ae-c857-24b8-a774-db6dab345a20.cfm

Created December 8, 2023 09:48
Show Gist options
  • Save trycf/cb6415f57016231662dd4396748c7918 to your computer and use it in GitHub Desktop.
Save trycf/cb6415f57016231662dd4396748c7918 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1702028917144-e60e36ae-c857-24b8-a774-db6dab345a20.cfm
<cfscript>
cfapplication( action="update", nullSupport=true);
var thisNull = nullValue();
dump( var=thisNull ?: 'is_null', label="from local" );
var q = queryNew( "nullField", "varchar", [ [ nullValue() ] ] );
dump( var=q.nullField ?: 'is_null', label="from db" );
dump( var=IsNull(q.nullField), label="Is null" );
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment