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

QueryPrepend

Last update:
May 18, 2026

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

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