12. SQL template files

12.1 sqledit_search_form.html
12.2 sqledit_sinsert_form.html
12.3 sqledit_edit.html
12.4 sqledit_search.html
12.5 hook_search.html
12.6 sqledit_remove.html
12.7 sqledit_remove_confirm.html
12.8 error.html
12.9 sqledit_requests.html

12.1 sqledit_search_form.html

`Example'

<title>Search form for _TABLE_</title> <h3>Search form for _TABLE_</h3> <form action=_SCRIPT_ method=POST> <input type=submit value=search> _HIDDEN_ <table> _DEFAULT_ </table> </form>

`Tags'

`_TABLE_'

The name of the database table.

`_HIDDEN_'

List of hidden fields necessary to perform the search. Must be included in each form.

`_DEFAULT_'

A two column table showing the name of the field and an input area, See section Database table tags. The input area is filled with the values from the cgi-bin parameters, if any. If no value is specified the input area is left undefined, the default value of the field, if any, is not used.

`table tags'

All the automaticaly generated tags for the database table are available, provided that _DEFAULT_ was not found in the template, See section Database table tags.

12.2 sqledit_sinsert_form.html

`Example'

<title>Insert form for _TABLE_</title> <h3>Insert form for _TABLE_</h3> <form action=_SCRIPT_ method=POST enctype=multipart/form-data> <input type=submit value=insert> _HIDDEN_ <table> _DEFAULT_ </table> </form>

Note the enctype=multipart/form-data, necessary if the table contains blobs, optional otherwise.

`Tags'

`_TABLE_'

The name of the database table.

`_HIDDEN_'

List of hidden fields necessary to perform the insertion. Must be included in each form.

`_DEFAULT_'

A two column table showing the name of the field and an input area, See section Database table tags. The input area is filled with the values from the cgi-bin parameters, if any. If no value is specified the input area is set with the default value as defined in the database.

`table tags'

All the automaticaly generated tags for the database table are available, provided that _DEFAULT_ was not found in the template, See section Database table tags.

12.3 sqledit_edit.html

`Example'

<title>Edit form for _TABLE_</title> _EDITCOMMENT_ <form action=_SCRIPT_ method=POST enctype=multipart/form-data> <input type=submit name=update value=update> _HIDDEN_ <table> _DEFAULT_ </table> </form>

Note the enctype=multipart/form-data, necessary if the table contains blobs, optional otherwise.

`Tags'

`_TABLE_'

The name of the database table.

`_EDITCOMMENT_'

A small comment from the action taken before the display of the template.

`_HIDDEN_'

List of hidden fields necessary to perform the update. Must be included in each form.

`_DEFAULT_'

A two column table showing the name of the field and an input area, See section Database table tags. The input area is filled with the values from the cgi-bin parameters, if any. If no value is specified the input area is set with the default value as defined in the database.

`table tags'

All the automaticaly generated tags for the database table are available, provided that _DEFAULT_ was not found in the template, See section Database table tags.

12.4 sqledit_search.html

`Example'

<title>Search _TABLE_</title> <h3>_TABLE_</h3> <table border=1> <!-- start entry --> <tr>_MARGINTABLE_ _DEFAULTTITLE_</tr> <tr>_MARGIN_ _LINKS_</tr> <tr>_MARGIN_ _DEFAULTROW_</tr> <!-- end entry --> </table> <!-- start pager --> Number of pages _MAXPAGES_ <p> _PAGES_ <!-- end pager -->

`Parts'

`entry'

This part is repeated for each record found. For more information about which records from which tables are displayed, See section Search table (search).

`pager'

See section Multipage results template.

`Tags'

`_TABLE_'

The name of the database table.

`_MARGINTABLE_'

Indentation including the name of the table.

`_MARGIN_'

Indentation.

`_DEFAULTTITLE_'

Cells listing the name of all the columns of the database. The order of the labels is the same as the order of the values from _DEFAULTROW_. The background of the cells is gray to improve readability.

`_LINKS_'

Hypertext links leading to actions on the displayed rows.

`Remove'

See section Remove confirm (remove_confirm).

`Edit'

See section Record edit form (edit).

`_DEFAULTROW_'

Cells listing the values of all the fields of the current row. The order of the labels is the same as the order of the values from _DEFAULTTITLE_.

`table tags'

All the automaticaly generated tags for the database table are available, provided that _DEFAULTROW_ was not found in the template, See section Database table tags.

12.5 hook_search.html

`Example'

<title>Search _TABLE_</title> <h3>_TABLE_</h3> <table border=1> <!-- start entry --> <!-- start table1,table2 --> <tr>_DEFAULTROW_</tr> <!-- end table1,table2 --> <!-- start table2,table3 --> <tr>_DEFAULTROW_</tr> <!-- end table2,table3 --> ... <!-- end entry --> </table> <!-- start pager --> Number of pages _MAXPAGES_ <p> _PAGES_ <!-- end pager -->

`Parts'

`entry'

This part is repeated for each record found. For more information about which records from which tables are displayed, See section Search table (search).

The sub parts of entry have a name built from the list of tables for which a match was found. Most of the time the list only contains one table name, See section Hook Fulcrum configuration file.

`pager'

See section Multipage results template.

`Tags'

`_TABLE_'

The name of the database table.

`_DEFAULTROW_'

Cells listing the values of all the fields of the current row.

`table tags'

All the automaticaly generated tags for the database table are available, provided that _DEFAULTROW_ was not found in the template, See section Database table tags.

12.6 sqledit_remove.html

`Example'

<body bgcolor=#ffffff> <center> <h3>Confirm removal of record from _TABLE_</h3> <form action=_SCRIPT_ method=POST> <input type=submit name=remove value=remove> <input type=hidden name=context value=remove_confirm> _HIDDEN_ </form> </center>

`Tags'

`_TABLE_'

The name of the database table.

`_HIDDEN_'

List of hidden fields necessary to perform the removal. Must be included in each form.

12.7 sqledit_remove_confirm.html

`Example'

<body bgcolor=#ffffff> <center> <h3>Record removed from _TABLE_</h3> </center>

`Tags'

`_TABLE_'

The name of the database table.

12.8 error.html

`Example'

<body bgcolor=#ffffff> <title>Error</title> <center><h3> Error<p> _MESSAGE_ </center></h3>

`Tags'

`_MESSAGE_'

The text of the error message.

12.9 sqledit_requests.html

`Example'

<title>Requests</title> <h3>Requests</h3> <table border=1> <!-- start entry --> <tr> <td bgcolor=#c9c9c9>Search <a href='_SCRIPT_?context=search_form &table=_RTABLE_ &limit=_RWHERE-CODED_ &links_set=_RLINKS_ &order=_RORDER-CODED_'>_LABEL_<a/></td> <td><a href='_SCRIPT_?context=edit &table=sqledit_requests &primary=_ROWID_'>Edit<a/></td> <td><a href='_SCRIPT_?context=remove &table=sqledit_requests &primary=_ROWID_'>Remove<a/></td> </tr> <!-- end entry --> </table> <p> <a href='_SCRIPT_?context=insert_form &table=sqledit_requests'>Insert a request</a> <br> <a href='_SCRIPT_?context=search_form &table=sqledit_requests'>Search a request</a> <br> <!-- start pager --> Number of pages _MAXPAGES_ <p> _PAGES_ <!-- end pager -->

`Parts'

`entry'

This part is repeated for each request. See section Search table (search).

`pager'

See section Multipage results template.

`Tags'

Note that most of the following tags are indeed fields of the sqledit_requests table and may be substituted with all legal variations, See section Database table tags.

`_RTABLE_'

Name of the table of the request.

`_RWHERE_'

Where clause of the request.

`_RLINKS_'

Relational scheme specification used to display records, pushed in the links_set parameter, See section Search table (search).

`_RORDER_'

Order by clause of the request.

`_LABEL_'

Textual label describing the purpose of the request.

`_SCRIPT_'

Absolute location of the cgi-bin script.