Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1554468945407-a32be588-8cca-2aa8-4fbb-550efc212a94.cfm

Created April 5, 2019 12:56
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/bb1a200d185f92d2f463cfa4ca8e8889 to your computer and use it in GitHub Desktop.
Save trycf/bb1a200d185f92d2f463cfa4ca8e8889 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1554468945407-a32be588-8cca-2aa8-4fbb-550efc212a94.cfm
<cfscript>
users = queryNew(
"id, firstname", "integer, varchar",
[
{ "id":1, "firstname": "Han" },
{ "id":2, "firstname": "Chewie" }
]
);
subUsers = queryExecute(
"select * from users order by firstname",
{},
{ dbtype="query", returntype="struct", columnkey="id" }
);
dump( subUsers );
dump( subUsers.getClass() );
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment