Creates an HTML or ASCII table from the results of an SQL query.
- db="database"
-
Which database to connect to, among the list of databases configured
under the "DBs" tab in the administrator interface. If omitted then
the default database will be used.
- host="url"
-
A database URL to specify the database to connect to, if permitted by
the module settings. If omitted then the default database will be
used.
The database URL is on this format:
driver://[username[:password]@]host[:port][/database]
where driver is the database protocol, e.g. "odbc",
"mysql", "oracle", "postgres", etc.
For compatibility this can also be a database name as given to the
"db" attribute.
- module="string"
-
Access the local database for the specified Roxen module, if
permitted by the module settings. This attribute is deprecated.
- query="SQL statement"
-
The actual SQL-statement.
- parse
-
If specified, the query will be parsed by the RXML parser. Useful if
you wish to dynamically build the query. This attribute is deprecated
and will have no effect if the server compatibility level is above 2.1.
- charset="string"
-
Use the specified charset for the SQL statement. See the description
of the same attribute for the "sql" emit source for more info.
- ascii
-
Create an ASCII table rather than an HTML table. Useful for
interacting with <diagram> or <tablify>.