QueryAppend()
Adds all values of one query to the end of another query. Both queries need to have the same columns.
Introduced: 6.0.0.15
QueryAppend( query1=query, query2=query );
Returns: Query
Argument | Description |
---|---|
query1
query,
required
|
query to add data. |
query2
query,
required
|
query to get data from. |
Examples
testQuery = queryNew( "name , age" , "varchar , numeric" , { name: [ "Susi" , "Urs" ] , age: [ 20 , 24 ] } );
newTestQuery = queryNew( "name , age" , "varchar , numeric" , [ [ "Smith" , 20 ] , [ "John", 24 ] ]);
queryAppend(testQuery, newTestQuery);
writeDump(testQuery);
See also
- Queries
- query.append()
- Search Issue Tracker
- Search Lucee Test Cases (good for further, detailed examples)