QueryAppend

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

Parameter

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

Query1_new

Query2

Query2_new

Appended query object

appended_query_objectnew