docs.roxen.comBack to normal mode
DocsRoxenWebServer 3.3Web Developer ManualEmit Tags
Copyright  2004, Roxen Internet Software
Suggestions, comments & compliments

<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.



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.


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='' value='texttexttext' />
<sqlquery query='insert into mytable VALUES (4,:foo,:bar)' 
          bindings=',' />