QueryPrepend

Description

Adds a query object at the beginning of another query object.

Returns

A query object.

Category

Syntax

QueryPrepend(query1, query2)

Member function

Query1.Prepend(Query2)

History

New in ColdFusion (2018 release) Update 5.

Parameters

Parameter

Required/Optional

Description

query1

Required

The query object to add at the end of the output object.

query2

Required

The query object that is to be 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)
	QueryPrepend(myquery1,myquery2)
	writedump(myquery1)
</cfscript>

Output

myQuery1

Query1_new

myQuery2

Query2_new

Prepended query object

prepended_query_objectnew