Lucee Function Reference

querynew()

Creates an empty query (query object).

Example

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

Category

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