QueryLazy()

edit

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
sql _{string, required}	edit SQL to execute
listener _{function, required}	edit listener function that will be called with the data of every single row. if returns false, execution is stopped.
params _{any, optional}	edit 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}
options _{struct, optional}	edit 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 39,211ms WARN No examples for function QueryLazy