Prepare query

XML

<db:prepare var="var" var_params="var">
    ixml
    <db:query>string</db:query>
</db:prepare>

<db:prepare /> prepares a database query. Arguments may be passed for identifier and literal substitution as parameters.

Attributes

Name	Type	Description	Defined By
var	var	Result variable name	db:prepare
var_params	var	Variable name for associated parameter name and value pairs	db:prepare

Results

Binding	Type	Predicate
var		N/A

Children

db:query

XML

<db:query>string</db:query>

Examples

XML

<output>
  <db:prepare>
    <param>ID</param>
    <param>contacts</param>
    <param>123</param>
    
    <db:query>
      <verbatim>SELECT $ FROM $ WHERE $0 = ?</verbatim>
    </db:query>
  </db:prepare>
</output>

<!-- SELECT "ID" FROM "contacts" WHERE "ID" = '123' -->