Lucee Function Reference

queryexecute()

Executes a SQL query, returns the result.

Example

queryexecute(string sql,[any params,[struct options]]):any

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  
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.