QueryExecute
Last updated
Last updated
Execute an SQL query and returns the results.
Argument | Type | Required | Description | Default |
---|---|---|---|---|
SQL Only Example. Assumes that a default datasource has been specified (by setting the variable this.datasource in Application.bx)
Use :structKeyName
in your sql then pass a struct with corresponding key names.
When passing with an array use the ?
symbol as a placeholder in your sql
sql
String
true
The SQL to execute
params
any
false
An array of binding parameters or a struct of named binding parameters
[]
options
struct
false
A struct of query options