Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1580268016667-9c4da25b-0add-7e1e-b9b2-1f553795dde1.cfm

Created January 29, 2020 07:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save trycf/600fd952bfc0353ed2cbe92531d7da6b to your computer and use it in GitHub Desktop.
Save trycf/600fd952bfc0353ed2cbe92531d7da6b to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1580268016667-9c4da25b-0add-7e1e-b9b2-1f553795dde1.cfm
<cfscript>
private void function test(){
DatabaseQuery = QueryExecute(
"SELECT Value FROM Numbers WHERE Value NOT IN ( :emptyList ) ",
{ emptyList = { value="", list=true } },
{ DataSource="RealDatabase" }
);
writedump(DatabaseQuery);
}
test();
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment