TryCF Gist

trycf-gist.cfm

<cfscript>
query function combineQueries(required query q1, required query q2) {
	return queryExecute(
		"SELECT * FROM q1 UNION SELECT * FROM q2",
		[],
		{dbtype = "query", q1 = q1, q2 = q2}
	);
}	


q1 = queryNew("id,mi,en", "integer,varchar,varchar", [
    [1, "tahi", "one"],
    [2, "rua", "two"]
]);
q2 = queryNew("id,mi,en", "integer,varchar,varchar", [
    [3, "toru", "three"],
    [4, "wha", "four"]
]);

q3 = combineQueries(q1,q2);

writeDump([q1,q2,q3]);

</cfscript>