Roxen Interactive RXML Help

<sqltable/>

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

Attributes

db

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

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

module=string

Access the local database for the specified Roxen module, if permitted by the module settings. This attribute is deprecated.

query

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

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