QueryAppend

Description

Adds a query object at the end of another query object.

Returns

A query object.

Category

Syntax

QueryAppend(query1, query2)

Member function

Query1.Append(Query2)

History

New in ColdFusion (2018 release) Update 5.

Parameters

Parameter

Required/Optional

Description

query1

Required

The query object to add at the beginning of the output object.

query2

Required

The query object that gets 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) 
 QueryAppend(myquery1,myquery2) 
 writedump(myquery1) 
</cfscript>

Output

Query1

Query2

Appended query object

 Adobe

Saage abi kiiremini ja hõlpsamalt

Uus kasutaja?

Adobe MAX 2024

Adobe MAX
Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis

Adobe MAX

Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis

Adobe MAX 2024

Adobe MAX
Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis

Adobe MAX

Loovuse konverents

14.–16. oktoobril Miami Beachis ja veebis