Lucee Function Reference
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]}); |