Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1673607405591-5cb17d45-0eed-2a6f-366c-c6461bc9dc50.cfm

Created January 18, 2023 15:44
Show Gist options
  • Save trycf/91a2db7d0767096bc1fc9d93f8caba93 to your computer and use it in GitHub Desktop.
Save trycf/91a2db7d0767096bc1fc9d93f8caba93 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1673607405591-5cb17d45-0eed-2a6f-366c-c6461bc9dc50.cfm
<cfscript>
news = queryNew("id,title",
"integer,varchar",
[ {"id":1,"title":"Dewey defeats Truman"}, {"id":2,"title":"Man walks on Moon"} ]);
pews = queryNew("id,title",
"integer,varchar",
[ {"id":3,"title":"Dewey defeats Truman"}, {"id":2,"title":"Man walks on Moon"} ]);
result = queryExecute("select * from news where id not in (select id from pews)",{},{dbtype="query"});
writeDump(result);
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment