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

myQuery2

Prepended query object