Whatever message this page gives is out now! Go check it out!

QueryAppend

Last update:
May 18, 2026

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

ParameterRequired/OptionalDescription
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

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page