Lucee Function Reference

querynew()

Creates an empty query (query object).

Beispiel

querynew(object columnNames,[object columnTypes,[any data]]):query

Kategorie

query

Argumente

Die Argumente für diese Funktion sind fest vorgegeben. Ausser den nachfolgenden Argumenten dürfen keine weiteren verwendet werden.
Name Typ Required Beschreibung
columnNames object  Yes column names for the query created, allowed are comma-delimited string lists or an array.  
columnTypes object  No column types for the query created, allowed are comma-delimited string lists or an array.  
data any  No data to populate the new Query, an array of arrays or an array of structs.
Example usage:
queryNew("name,age","varchar,numeric",[["Susi",20],["Urs",24]]);
queryNew("name,age","varchar,numeric",[[name:"Susi",age:20],[name:"Urs",age:24]]);
queryNew("name,age","varchar,numeric",{name:["Susi","Urs"],age:[20,24]});