Tags · Functions · Objects
Lucee Function Reference
Choose a function:

Function QUERYNEW

Creates an empty query (query object).

Example

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

Arguments

The arguments for this function are set. You can not use other arguments except the following ones.
Name Type Required Description
columnNames object  Yes column names for the query created, allowed are comma-delimited string lists or a array.  
columnTypes object  No column types for the query created, allowed are comma-delimited string lists or a array.  
data any  No data to populate the new Query, a array of arrays or a 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]});