Executes a SQL query without loading the data entirely to memory. Instead it calls the given Function with every single row

QueryLazy( sql=string, listener=function, params=any, options=struct );

Returns: void

Argument Description
string, required

SQL to execute

function, required

listener function that will be called with the data of every single row. if returns false, execution is stopped.

any, optional

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

Alias: param

struct, optional

Struct containing query options, all cfquery tag attributes are supported except the name attribute.

Alias: option, queryOptions


There are currently no examples for this function 23,037ms WARN No examples for function querylazy

See also