Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1642618367093-a9d9b7e8-a7c1-e68c-53aa-dae12e40e6e5.cfm

Created January 19, 2022 18:53
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/1fea9bdfd6e31a100159c2cd4be31899 to your computer and use it in GitHub Desktop.
Save trycf/1fea9bdfd6e31a100159c2cd4be31899 to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1642618367093-a9d9b7e8-a7c1-e68c-53aa-dae12e40e6e5.cfm
<cfscript>
employees = queryNew( 'name,foo', 'varchar,varchar',[
['Brad','cm_4test5'],
['Luis','yeah']
]);
actual = QueryExecute(
sql = "SELECT * from employees WHERE foo LIKE 'cm_[0-9]%[0-9]'",
options = { dbtype: 'query' }
);
writedump( actual );
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment