Run query
XML
<db:run var="var" type="num">
string
</db:run>
Parents: db:connection
<db:run /> executes an arbitrary SQL statement and retrieves the accordant result set from the database.
Attributes
| Name | Type | Description | Defined By |
|---|---|---|---|
| var | var | Result variable name for retrieved result set | db:run |
| type | type | Result set type | db:run |
Results
| Binding | Type | Predicate |
|---|---|---|
| var | array | no-result-propagation |
Examples
XML
<db:run var="data" type="assoc">
SELECT * FROM "contacts"
</db:run>