QueryPrepend

Description

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

Returns

A query object.

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.

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

Adobe

Get help faster and easier

New user?