docs.roxen.comView this page in a printer friendly mode
DocsRoxenWebServer 6.1Web Developer ManualDatabase Tags
Copyright  2018, Roxen Internet Software
Suggestions, comments & compliments
manuals@roxen.com
 DEMO  DOCS  PIKE
 COMMUNITY  DOWNLOAD
www.roxen.com



<ldap>
<sqlquery>
<sqltable>

<sqltable/>

Provided by module: Tags: SQL tags

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


Attributes

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