Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1641331465786-99162b47-44e6-b998-84df-4c116ceb6453.cfm

Created January 4, 2022 21:26
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/07e469dd35fb17666d3909facfe6e214 to your computer and use it in GitHub Desktop.
Save trycf/07e469dd35fb17666d3909facfe6e214 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1641331465786-99162b47-44e6-b998-84df-4c116ceb6453.cfm
<cfscript>
employees = queryNew( 'name,age,email', 'varchar,integer,varchar',
[
[ 'John Doe',28,'John@company.com' ],
[ 'Jane Doe',22,'Jane@company.com' ],
[ 'Bane Doe',28,'Bane@company.com' ]
] );
actual = QueryExecute(
sql = "SELECT name from employees ORDER BY age, email",
options = { dbtype: 'query' }
);
dump( actual )
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment