Go to the first, previous, next, last section, table of contents.

Database table tags

Most templates display fields from tables and they all follow the same conventions. If the template documentation states that a record from table table is available in a specific part of the template, a set of tags is automatically available.

`_FIELDNAME_'
The value of the field, verbatim. As a special case, if the field is of type blob, and img tag is generated to display the content of the field. It must be a GIF file.
`_FIELDNAME-QUOTED_'
The value of the field, with all characters that would cause problems in HTML (quote, double quote, lower than and greater than) replaced by their symbolic form. This is suitable for insertion in the value part of an input tag, for instance.
`_FIELDNAME-CODED_'
The value of the field, with all characters that would cause problems in an URL (space, ampersand and all so called unsafe characters) replaced by their hexadecimal form. This is suitable for insertion in the URL part of an a tag, for instance.
`_FIELDNAME-MENU_'
Only suitable for fields of type set or enum. Display the current value of the field within a select style menu listing all the allowable values of the field. If the type of the field is set, the menu generated allows multiple selection. The exact display generated depends on the definitions found in the sqledit.conf file, See section SQL editor configuration file.
`_FIELDNAME-RADIO_'
Only suitable for fields of type enum. Display the current value of the field within a table of radio buttons. The radio button associated with the current value is checked. The exact display generated depends on the definitions found in the sqledit.conf file, See section SQL editor configuration file.
`_FIELDNAME-CHECKBOX_'
Only suitable for fields of type set. Display the current values of the field within a table of checkboxes. The check boxes associated with the current values is checked. The exact display generated depends on the definitions found in the sqledit.conf file, See section SQL editor configuration file.

The tags listed above may be prefixed by the name of the table to disambiguate.

This form is only necessary if to tables have the same field name and a part of the template provide a record from both of them.

Each datatype has a default display form that is used when nothing is specified in the template. Here is an association between the MySQL datatypes and the default display associated with them.

`char of size 1'
Input text of size two.
`char of size > 30 and < 1000'
Input text of size thirty.
`char of size > 1000'
Text area of six rows and thirty columns.
`integer'
Input text of size ten.
`date or time'
Input text of size twenty.
`blob'
File upload.
`set'
Table of checkboxes, See section SQL editor configuration file.
`enum'
Single choice menu, See section SQL editor configuration file.

Go to the first, previous, next, last section, table of contents.