cfdocs

queryAppend

Adds a query to the end of the current query.

queryAppend(query1, query2)
returns query

Member Function Syntax

qry.append(query2)

Argument Reference

Name Type Required Default Description
query1 query Yes   The initial query object.
query2 query Yes   The query being added.

Builds a simple query using queryNew and queryAppend

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);