<emit source="sql"></emit>

Provided by module: Tags: SQL tags

Use this source to connect to and query SQL databases for information. The result will be available in variables named as the SQL columns.

Attributes

host="database"

Which database to connect to, usually a symbolic name set in the SQL Databases module. If omitted the default database will be used.

query="SQL statement"

The actual SQL-statement.

bindings=""name=variable,name=variable,...""

Specifies binding variables to use with this query. This is comma separated list of binding variable names and RXML variables to assign to those binding variables. Note: For some databases it is necessary to use binding variables when inserting large datas. Oracle, for instance, limits the query to 4000 bytes.

<set variable='var.foo' value='texttexttext' /> <sqlquery query='insert into mytable VALUES (4,:foo,:bar)' bindings='foo=var.foo,bar=form.bar' />