Parameter
Last updated on
Apr 27, 2021
Description
Adds a query object at the end of another query object.
Returns
A query object.
Category
Syntax
QueryAppend(query1, query2)
Member function
Query1.Append(Query2)
History
New in ColdFusion (2018 release) Update 5.
Parameters
|
|
Required/Optional |
Description |
|---|---|---|
|
query1 |
Required |
The query object to add at the beginning of the output object. |
|
query2 |
Required |
The query object that gets added to query1. |
See also
Example
<cfscript>
myQuery1=queryNew("empid,depid,name", "integer,integer,varchar",[
[10, 101, "John"],
[20, 120, "James"],
[30, 205, "Peter"]
]);
myQuery2=queryNew("empid,depid,name","integer,integer,varchar",[
[40, 530, "Jacob"],
[50, 306, "Mary"],
[60, 120, "Helen"]
])
writedump(myquery1)
writedump(myquery2)
QueryAppend(myquery1,myquery2)
writedump(myquery1)
</cfscript>
Output
Query1
Query2
Appended query object
