Lucee Function Reference
querylazy()
Executes a SQL query without loading the data entirely to memory. Instead it calls the given Function with every single row
Example
querylazy(string sql,function listener,[any params,[struct options]]):void
Category
query
Arguments
The arguments for this function are set. You can not use other arguments except the following ones.
Name | Type | Required | Description |
---|---|---|---|
sql | string | Yes | SQL to execute |
listener | function | Yes | listener function that will be called with the data of every single row. if returns false, execution is stopped. |
params | any | No |
Array or Struct of parameter values. When passing an array use ? as place holders. When passing a struct use :keyName where keyName is the name of the key in the structure corresponding to the parameter. The struct or array can be a struct with keys such as the following: cfsqltype, list |
options | struct | No | Struct containing query options, all cfquery tag attributes are supported except the name attribute. |