The database tags interact with SQL databases. They can be used to create interactive graphical reports as well as complete web applications.

The database tags are almost always combined with other RXML tags. Together with the <diagram> tag they provide real-time diagrams, with the <tablify> tag they provide nice looking tables. Combined with the <wizard> tag they make easy-to-use web applications.

Each database tag needs to know which database it should connect to. This is specified by the host-attribute which usually is a symbolic name for the database that the administrator has configured in the SQL databases module. It is also possible to specify the database host, user and password directly in the tags, but this is not recommended. See the Database chapter in the Administrator's manual for the syntax.

The database tags are:

<sqlquery>

Executes an SQL query.

<sqltable>

Creates an ASCII or HTML table with the results from an SQL query.

<sqloutput>

Insert the results of an SQL query into HTML or RXML code.