[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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  


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.


[ << ] [ >> ]           [Top] [Contents] [Index] [ ? ]

This document was generated by root on October, 27 2004 using texi2html