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

Attributes

ascii

Create an ASCII table rather than a HTML table. Useful for interacting with the <diagram> and <tablify> tags.

host=database

Which database to connect to, usually a symbolic name. If omitted the default database will be used.

query

The actual SQL-query.

quiet

Do not show any errors in the page, in case the query fails.

parse

If specified, the query will be parsed by the RXML parser. Useful if you wish to dynamically build the query.

Example

<tablify preparse nice>Country	Population
<sqltable ascii host=test query="SELECT country, population FROM
countries ORDER BY country">
</tablify>