queryAppend

Adds a query to the end of the current query.

queryAppend(query1, query2) → returns query

Member Function Syntax

qry.append(query2)

This function requires Adobe ColdFusion 2018.0.5 and up.  Not supported on Lucee, etc.

Argument Reference

query1 query
Required

The initial query object.

query2 query
Required

The query being added.

Examples
Sample code invoking the queryAppend function

Add new query to the end of the current query using queryAppend.

names = queryNew("empl_id,name", "integer,varchar", [["empl_id"=1239,"name"="John"]]);
newnames = queryNew("empl_id,name", "integer,varchar", [["empl_id"=1501,"name"="Jane"]]);
queryAppend(names, newnames);
writeDump(names);

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub