queryPrepend

Adds a query to the beginning of the current query.

queryPrepend(query1, query2) → returns query

Member Function Syntax

qry.prepend(query2)

This function requires Adobe ColdFusion 2018.0.5 and up.  Not supported on Lucee, etc.
  1. CFDocs
  2. Functions
  3. Query Manipulation Functions
  4. queryPrepend
  5. CF2018.0.5+
  6. 0 Issue
  7. Edit
See Also:   queryAppend

Argument Reference

query1 query
Required

The initial query object.

query2 query
Required

The query being added.

Examples
Sample code invoking the queryPrepend function

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

names = queryNew("empl_id,name", "integer,varchar", [["empl_id"=1239,"name"="John"]]);
newnames = queryNew("empl_id,name", "integer,varchar", [["empl_id"=1501,"name"="Jane"]]);
queryPrepend(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