Skip to content

Instantly share code, notes, and snippets.

Created February 18, 2015 19:44
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 anonymous/47d9508d9e7c3ef20d96 to your computer and use it in GitHub Desktop.
Save anonymous/47d9508d9e7c3ef20d96 to your computer and use it in GitHub Desktop.
TryCF Gist
<cfscript>
q1 = queryNew( "id,name", "integer,varchar", [
{id=1,name="One"},
{id=2,name="Two"},
{id=3,name="Three"}
]);
qoq = new Query(
dbtype = "query",
sql ="SELECT * FROM notQ WHERE id <> 3 ",
notQ = q1
).execute();
writeDump([
q1,
qoq.getResult()
]);
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment