Lucee Function Reference
Function QUERYEXECUTE
Executes a SQL query, returns the result.
Example
queryexecute(string sql,[any params,[struct options]]):any
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. |