Skip to content

Instantly share code, notes, and snippets.

@trycf

trycf/trycf-gist-1572124499046-564908d8-8952-db39-f71d-037ae38b13d8.cfm

Created October 26, 2019 21:19
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/14a9f55a03f2c56de7a2c8ac5bee0f6a to your computer and use it in GitHub Desktop.
Save trycf/14a9f55a03f2c56de7a2c8ac5bee0f6a to your computer and use it in GitHub Desktop.
Download ZIP
TryCF Gist
Raw
trycf-gist-1572124499046-564908d8-8952-db39-f71d-037ae38b13d8.cfm
<cfscript>
qry1 = queryNew( 'col1,col2', 'varchar,varchar' );
qry2 = queryNew( 'col1,col2', 'varchar,varchar' );
qry1.addRow( [ 'val1', 'val2' ] )
qry2.addRow( [ 'val1', 'val2' ] )
cfquery( dbtype="query" ,name="qry3" ) {
writeOutput( 'SELECT * FROM qry1 UNION SELECT * FROM qry2' );
}
writedump( qry3 );
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment