Work with HTML Templates

Overview

Use TemplateMaker to create HTML pages and incorporate database calls into those pages, specifying the style and format for data submitted and returned. TemplateMaker provides an easy interface for working with HTML tags although, if you prefer working in another HTML editing program, you can create pages in that program and use TemplateMaker just for coding the database interactions. Use SQLEditor to enter the SQL statements that your templates use to retrieve and post data. Your templates refer to a SQL statement by its command ID.

To work with TemplateMaker, you should be familiar with the HTML specification version 3.2 or later. For more information, refer to the World Wide Web consortium Web site.

Procedures

Start TemplateMaker

From the Start menu, point to Programs, and click TemplateMaker.
Complete the XLiRAD Client Login dialog box and click Submit.
Complete the Group Selection dialog box and click Submit..

Create a New Template

In TemplateMaker, click .
Or from the File menu, click the New command.
In the window that appears, use HTML tags or XLiRAD tags to design your page.
When finished, click the option you want:
You can work on multiple templates simultaneously by creating several new templates or opening a group of existing templates.

Open a Local Template

In TemplateMaker, click .
Or from the File menu, click the Open Local command.
In the Open Template: Local Drive dialog box, double-click the name of a template.
The template appears in the TemplateMaker window.

Save a Local Template

In a new or an existing template, click .
Or from the File menu, click the Save Local command.
The Save Template: Local Drive dialog box appears if you are creating a new template. This does not appear when you save changes to an existing template.
In the Save Template: Local Drive dialog box, type a file name for the template and click Save.

Open a Template on the Server

In TemplateMaker, click .
Or from the File menu, click the Open From Server command.
In the Open Template: Server dialog box, click the name of a template and click Select.
The template appears in the TemplateMaker window.

Save a Template on the Server

In a new or an existing template, click .
Or from the File menu, click the Save on Server command.
In the Save Template As: Server dialog box, complete the following:
- In the Template Name box, type the name of the template.
- In the Template Type box, click Public Domain or Administrative.
  Public domain templates appear under the Templates folder; administrative templates appear under the Admintemplates folder on the server.

Check In a Template

In a new or an existing server template, from the File menu, click Check In.
The Template Check In dialog box shows the template name and username.
In the Template Check In dialog box, type a revision comment and click Submit.
Notice that the the status bar changes from Editable to Read Only.
To check out the template again, see Open a Template on the Server.

Remove Text from a Template

In a template, drag the pointer over the text you want to remove.
Click .
Or from the Edit menu, click Cut.

Copy Text from a Template

In a template, drag the pointer to select the text you want to copy.
Click .
Or from the Edit menu, click Copy.

Paste Text into a Template

In a template, place the pointer where you want to paste cut or copied text.
Click .
Or from the Edit menu, click Paste.

Search for Text in a Template

In a template, from the Edit menu, click Find.
The Template Search dialog box appears.
In the Search String box, type the text you want to find.
Select the Case Sensitive check box if appropriate.
Click Search.

Search for and Replace Text in a Template

In a template, from the Edit menu, click Replace.
The Search and Replace dialog box appears.
In the Search Text box, type the text you want to find.
In the Replace Text box, type the replacement text.
Select the Match Case or Confirm check boxes as appropriate.
Click Replace.
If you selected Confirm, TemplateMaker prompts you to confirm replacements; otherwise, TemplateMaker replaces text automatically.

Update Data from the Server

In TemplateMaker, click .
Or from the File menu, click the Refresh Server Data command.

Print a Template

In TemplateMaker, click .
Or from the File menu, click the Print command.

View Revisions

From the File menu, click Revision Viewer.
The Revision Template Selection dialog box appears.
In the Template list box, click the name of the revised template and click View Revisions.
In the Revision Selection dialog box, click the revision you want to display and click Submit.
The dialog box lists revisions by number, date, author, and comment.
In the Revision Viewer dialog box, notice the template that appears. Click Reactivate to restore the original template. Otherwise, click Done.

Restore a Revised Template

From the File menu, click Revision Viewer.
In the Revision Viewer Selection dialog box, click the name of the template.
In the Revision Selection dialog box, click the version of the template you want to restore and click Submit.
Under Revision Viewer, confirm that this is the correct version and make any changes you want. Then click Reactivate.

Design an HTML Page

In TemplateMaker, position your cursor where you want the tags to appear. Notice that HTML tags appear in blue, with their attributes in pink.
From the HTML Tags menu, click the menu command and tag for the appropriate syntax and click Submit. For information, see the following table.
Unless otherwise noted, the default for all settings is "Unspecified."
TemplateMaker does not validate the HTML syntax.

To define	Use
Basic document structure such as centering text, using a style sheet, and so on	Document
Applets, scripts, ActiveX controls, and so on	Executable
Form input data, select lists, buttons, and so on	Forms
Frames in a page	Frames
Images to display and image maps	Images
Anchor tags for links	Links
Definition, ordered, or unordered lists	Lists
Table caption, size, rows, and columns	Tables
Text format such as bold, line breaks, citations, and so on.	Text

Incorporate Data and Dynamic Behavior in a Page

Position your cursor where you want the tags to appear. Notice that XLiRAD tags appear in colors:
- <CMD>
- <REP>, <REP2>
- <INC>
- <ERR>
Set up an HTML table as appropriate for formats (such as <CMD> with Table or Row) before inserting the tags.
From the XLiRAD Tags menu, click the menu command and tag for the appropriate syntax. For information, see the following table. When finished, click Submit.

To define	Use
Format of data retrieved from a database. Options include tables, radio buttons, check boxes, select lists, and so on. Processed after <REP>.	<CMD>
Text and template used for display of error messages requested by another template. Processed after the <CMD> tag if an error arises.	<ERR>
Insertion of another template in a current template. Processed first among XLiRAD tags.	<INC>
Replacement of page variables with data retrieved from a database. Processed after <INC>.	<REP>
Replacement of page variables from a result set different from the one used with a preceding <REP> tag. Processed after <CMD> provided no error occurs.	<REP2>

Reference

Use the following user-interface elements of TemplateMaker to create and manage templates in XLiRAD:

For information about dialog boxes presented when you work with TemplateMaker, see:

TemplateMaker Window

The TemplateMaker provides a user interface for viewing, authoring, and editing standard HTML and custom command syntax used in templates.

As shown in the following illustration, the TemplateMaker window provides access to functions through toolbar buttons, window menus, and a shortcut menu.

Click to expand image

A status bar at the bottom of the window provides the following information about the current template:

Server Connection Data: Shows server name, port number, user name, and group in use
Template Source: Server or Local
Template Status: Editable or Read Only; if previously checked in, shows "Checked Out" when opened; if checked out and edited, shows "Modified"

As shown in the following illustration, the Command Tag dialog box provides a sample output box where you can view a typical display that might result from using the specific tag attribute.

Click to expand image

Toolbar Buttons

Button	ToolTip
	New Template
	Open Local Template
	Print Template
	Browser View
	Save Template Locally
	Open Template From Server
	Save Template On Server
	Cut Text
	Copy Text
	Paste Text
	<CMD>
	<ERR>
	<INC>
	<REP>
	<REP2>
	Refresh Server Lists

Menus

File Menu

Use the File menu to manage template files on the server or on the local computer.

Command Name	Description
New	Presents a blank area in the TemplateMaker window for creating a new template.
Open Local	Opens a template stored on the local computer.
Save Local	Saves a template on the local computer.
Save As Local	Saves a template under a new name on the local computer and leaves original template intact.
Open From Server	Opens a template stored on the server.
Save On Server	Saves a template on the server.
Save As On Server	Saves a template under a new name on the server and leaves original template intact.
Check In	Saves the current template to the server and sets it to read-only mode.
Revision Viewer	Presents a window for display of comments describing revisions to a template.
Browser View	Displays the template as it would appear in an HTML browser.
Refresh Server Data	Connects to the server and displays the current template data.
Print	Outputs the template to a printer.
Exit	Closes the TemplateMaker user interface.

Edit Menu

Use the Edit menu to manipulate text in a template.

Command	Description
Cut	Removes selected text from its current cursor position in the current template and copies it to the Clipboard. You can paste it into another area of the template or into another template.
Copy	Copies selected text from the current cursor position in the current template into the Clipboard. You can paste it into another area of the template or into another template.
Paste	Adds at the cursor position any text that you placed in the Clipboard using Cut or Copy.
Find	Displays a dialog box where you can specify text to locate in the current template.
Find Again	Repeats a search defined using the Find command.
Replace	Displays a dialog box where you can specify text to locate as well as text to paste in its place.

XLiRAD Tags Menu

The XLiRAD Tags menu provides menu commands that display dialog boxes for defining how your template page presents data retrieved from the database by means of SQL statements defined in SQLEditor. The menu contains the following commands.

<CMD>	<REP>
<ERR>	<REP2>
<INC>

FormProcessor, the DBServer component that processes templates, interprets XLiRAD tags in the following order:

<INC>
<REP>
<CMD>
<ERR>, if an error occurs
Or <REP2> if no error occurs

<CMD> Tabs

Use the option tabs to define the format you want. TemplateMaker inserts beginning and ending <CMD> tags followed by the available options and the values you define in the format dialog box. The template strings these options and values together in the syntax:
&OPTION_NAME=your_value

Message or comment text (if supported in the dialog box for the format) appears in square brackets.

All formats support error handling.

For an illustration of how a browser might display tag format, see the Sample Output box in the right corner of the Command Tag dialog box.

To modify <CMD> tag settings, right-click the tag code and point to Edit Command.

Option	Description
Address	Retrieves data from fields in a database and displays it as up to five lines containing name, street address, an optional address, and city, state, and postal code, respectively.
Check	Retrieves data from fields in a database and displays it as options beside a set of check boxes. Use the check-box format to give the user the option of enabling or disabling one or more features in a group.
Edit	Retrieves data from fields in a database and formats it in a text-entry box in the HTML page that you can use to update data in the database table. The template formats the data with two columns: the column name and a text box completed with the values from the query.
External	Runs functions you define in an external Java file. Name the file "ExternalFunctions.java" and numerically index each function. In the template specify the function you want from the function list. Store the function file under "Classes" in the "Dbserver" folder and make sure to compile it into a class file. To view sample external functions, see the ExternalFunctions.java file installed on the server computer by DBServer setup.
Insert	Retrieves data from fields in a database and formats it as input for an HTML form that you can use to submit data back into the database table.This format creates a set of table rows consisting of the column names in one cell, and edit fields in the other. Create your HTML form and table using the output from this format.
Loop	Retrieves data to submit to another statement as input.
None	Submits data to the database that does not require output to a template. Use with INSERT, UPDATE, and DELETE queries that do not require any output.
Pairs	Add name-value pairs for use on the template without creating screen output. When used, each subsequent command on the template has access to the new variables created by this format.
Radio	Retrieves data from fields in a database and displays it as options beside a set of radio buttons.The associated SQL statement must retrieve two fields. Use radio buttons when you want a user to choose to enable or disable only one of a group of features
Row	Retrieves data from fields in a database table to display in rows of an HTML table. Another template serves as the model for the row output of the table. In that template, use the <REP> and <REP2>tags where you want to place output of the particular row.
Select	Retrieves data from fields in a database and displays it as options in a select list.
Table	Retrieves data from fields in a database table to display in columns in an HTML table.
Text	Retrieves data from fields in a database and displays it as a comma-separated string of values.Use this format for single-column, single-result queries where you only want to display the result and don't need to use the data at another position in the template.
Tree	Retrieves data from fields in a database and displays it as a contents "tree" with "nodes" for the items at various levels of the tree.

Address

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor. The statement must contain a SELECT operation that retrieves one row with six columns containing data in this order: 1 name 2 first address line 3 second address line (or NULL) 4 City 5 State 6 ZIP Code
Error Condition	A type of error handling. The options are: None.The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	The name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	Select this check box to convert null values to spaces.

Check

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor. The statement must return a two column result set. The template assigns the name of the first column to the check boxes. In addition, the template assigns the values of the first column as the values of the check boxes and the displays the values of the second column on the page.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.

Edit

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor. The statement contain return a single row. If the query produces multiple rows, the template uses only the first row.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Hidden Fields	The names of fields (columns) that the template should not display. Data specified as hidden is still available for use on the form.
Static Fields	The names of fields (columns) that the template should not display but which should not be available for editing use in the form.

External

Complete the options as needed and click Submit.

For this option	Type or click
Known External Functions	An external function ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.

Insert

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Ignored Columns	The names of the columns (fields) that you want to omit from the template data.

Loop

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor. This statement retrieves the initial result set and creates variables for each row with the column name as the name of the variable.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Execution ID	The number of the SQL statement that receives data from the preceding statement. This statement must process the variables input from the preceding statement one row at a time.
Break on Error	This check box to terminate the "looping" of data from the first statement to the next when an error occurs.

None

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.

Pairs

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor. The statement should contain a SELECT operation that returns a single row. The template creates a name-value pair from the row data. The name-value pair associates a column name from the query with its value to form a new variable for use throughout the template. If the query returns multiple rows, the template uses only the values from the first row for the name-value pair. If the result set from the query is empty, TemplateMaker creates no new variables.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Money Fields	The names of fields (columns) that contain monetary values. TemplateMaker rounds these values to two decimal places. Notice that TemplateMaker does not precede these values with a dollar sign ($) so you can treat the values as floating-point variables.)

To substitute values in the template after using Pairs, use <REP2> rather than <REP> for the substitution. Because TemplateMaker executes <REP> tags before all other commands and tags, including <CMD> and < Pairs >, using the <REP> would cancel the effect of those tags.

Radio

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor. The statement must be a two-column query. The template assigns the name of the first column to the radio control. In addition, the template selects the values of the first column in the control, and displays the values of the second column in the template.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Selected Value	The column (field) name from the statement for which a radio-button value appears selected in the template. By default, the template shows the first value from the statement selected.

Row

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Row Template	The name of the template used for formatting row data.
Rows Per Page	The maximum number of rows to display on the table for a large result set. The default page size for table formats is 25 rows. If the number of rows in the table exceeds the value for Rows Per Page, XLiRAD automatically breaks the pages and inserts "Next" and "Previous" links beneath the table for navigation through the remaining pages.

Select

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor. The statement must be a two-column query. The template assigns the name of the first column to the list control. In addition, the template selects the values of the first column in the control, and displays the values of the second column in the template.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Selected Value	The column (field) name from the statement for which a value appears selected in the template. By default, the template shows the first value from the statement selected.

Table

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Hidden Fields	The name of data-table columns (fields) that should not appear in the template as a column name. You might use this field for a link.
Use Auto Header	This check box to create a row of headers with the field names from the SQL statement.
Money Fields	The name of any data-table column (field) that contains a monetary value. When displayed, the value appears preceded by a dollar sign and rounded to two decimal places.
Show Row Count	This check box to display the number of rows at the bottom of the table.
Row Colors	To define a single background color for the table, A color in the only leftmost list box. To define two alternating colors, A color in both the left and right list boxes.
Link Column	The name of the column (field) in this result set that you want to link to from another template.
Link Template	A name of the template to link to.
Link Fields	The name of a field to send to the linked template. Separate the link fields with commas.
Rows Per Page	The maximum number of rows to display on the table for a large result set. The default page size for table formats is 25 rows. If the number of rows in the table exceeds the value for Rows Per Page, XLiRAD automatically breaks the pages and inserts "Next" and "Previous" links beneath the table for navigation through the remaining pages.

Text

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.

Tree

Complete the options as needed and click Submit.

For this option	Type or click
Command ID	The number of the SQL statement as it appears in SQLEditor.
Error Condition	A type of error handling. The options are: None. The template displays nothing when an error occurs. Empty Result Set. The current template displays an error template when the server responds that the result set is empty when it should contain data. Use the Error Template list box to identify the template. Result Set Exists. The current template displays an error template when the server responds that there is a result set when it should be empty. Use the Error Template list box to identify the template.
CommandName	A name for the SQL statement identified by number under Command ID.
Error Template	A name of the template you want displayed when an error occurs.
Error Message	Custom text to display in the error template.
Mask Null Values	This check box to convert null values to spaces.
Tree Node	The field names from the statement as the nodes of the tree. Specify the nodes in order from highest to lowest and separate column (field) names with commas. To skip a field, type two consecutive commas. To skip the first column (field), start the list with a comma. The template does not display column (field) names if their names don't appear in this box.
Tree Links	The names of the templates that you want nodes to link to, if any. If none, leave this box blank. When typing multiple template names, separate the names with commas.

Do not use this attribute with an extremely large result set. Tree does not have paging functionality; therefore, TemplateMaker converts the entire result set into a tree. When working with a very large result set, this conversion might result in a substantial strain on the servlet manager's memory resources and possibly cause low-memory errors.

<ERR>

Use <ERR> to display errors generated from commands on the current template or another template. The <ERR> tag inserts the ERROR= attribute with a value that corresponds to the error message text. If no error occurs, TemplateMaker discards the <ERR> tag.

Complete the options as needed and click Submit.

For this option	Type or click
Previous Template	The name of a template or accept the default shown (the previous template used) to display when an error occurs.

<INC>

Use the <INC> tag to include other templates in the current template. TemplateMaker processes <INC> tags before other commands.

Complete the options as needed and click Include.

For this option	Type or click
Template Name	A name of the template to include in this list box.
Cache Template	This check box to have TemplateMaker retain the template in the cache for better performance.

<REP>

Use <REP> to replace variables declared in a template with values retrieved earlier from the database using a different template linked or redirected to the current template. TemplateMaker processes <REP> tags after INC tags. Complete the options as needed and click Submit.

For this option	Type or click
Variable for Substitution	The name of the variable you inserted in the template. TemplateMaker replaces that variable with the data retrieved from the database, if any. Otherwise, TemplateMaker disregards the variable.
Use URL Encoding	This check box to pass the variable in encoded form in the template's URL.

<REP2>

Similar to <REP>, use <REP2> to replace variables declared in a template with values retrieved earlier from the database using a different template linked or redirected to the current template. However, unlike REP, you can also use REP to replace data retrieved by commands in the current template. TemplateMaker processes <REP2> tags after all other tags except <ERR>.

Complete the options as needed and click Submit.

For this option	Type or click
Variable for Substitution	The name of the variable you inserted in the template. TemplateMaker replaces that variable with the data retrieved from the database, if any. Otherwise, TemplateMaker disregards the variable.
Use URL Encoding	This check box to pass the variable in encoded form in the template's URL.

HTML Tags Menu

The HTML Tags menu provides commands that display dialog boxes used to define the HTML syntax and effects used on a template page. The menu contains the following commands.

Document	Links
Executable	Lists
Forms	Tables
Frames	Text
Images

Document Options

Option	Used to
<BODY>	Define a background image, background and text colors, class, style, and link colors
<CENTER>	Insert starting and ending tags for centered text.
<HR>	Define the appearance of a horizontal row in this page.
<STYLE>	Insert a tag for specifying a cascading style sheet (.css) file used for this page.

<BODY>

Complete the values as appropriate and click Submit.

For this option	Type or click	Example
Background Color	A color in this list box.	BGCOLOR="Blue"
Text Color	A color in this list box.	TEXT="Fuchsia"
Class	The name of the class that you want the tag to use.	CLASS="class_name"
Style	The name of the style that you want the heading level tag to use.	STYLE="style_name"
Background Image	The name of an image file to display.	BACKGROUND= "image_file_name"
Link Color	A color in this list box.	LINK="Lime"
Visited Link Color	A color in this list box.	VLINK="Black"
Active Link Color	A color option in this list box.	ALINK="Teal"

<HR>

Complete the values as appropriate and click Submit.

For this option	Type or click	Example
Identification	An identifier for this tag. This can be a numeral or a name.	ID="ID_name".
Alignment	An alignment attribute in this list box. Left, Center, and Right are available options.	ALIGN="Left".
Class	The name of the class that you want the tag to use.	CLASS="class_name".
Style	The name of the style that you want the heading level tag to use.	STYLE="style_name".
Size	A value for the thickness of the rule.	SIZE="value"
Width	A value for the width of the rule.	WIDTH=" value "

Executable Options

Option	Used to
<APPLET>	Define a Java applet to run in this page.
<EMBED>	Define an object to include on this page (for browsers other than Microsoft Internet Explorer Netscape Navigator version)
<OBJECT>	Include an ActiveX control on this page.
<PARAM>	Specify parameters for a control.
<SCRIPT>	Define JavaScript or VBScript to run on this page.

<APPLET>

Complete the dialog box options and click Submit.

For this option	Type or click	Example
Code	The name of the file that contains the applet.	CODE=" applet_file_name"
Code Base	The URL for the folder that contains the applet.	CODEBASE="URL"
Archives	The name of the archive file that contains the compressed applet.	ARCHIVE="file_name"
Height	The height used for display of the object in relation to the entire page.	HEIGHT="value"
Width	The width used for display of the object in relation to the entire page.	WIDTH="value"
Horizontal	The amount of horizontal space on the left and right of the applet display.	HSPACE="value"
Vertical	The amount of vertical space above and below the applet display.	VSPACE="value"
Name	A name used to refer to an instance of this applet in the page. When you have multiple applets in the page, they can communicate with each other using this reference.	NAME="instance_name"
ID	An identifier for this tag. This can be a numeral or a name.	ID="ID_name"
Alignment	An alignment attribute in this list box. Left, Center, and Right are available options.	ALIGN="Left"
Class	The name of the class that you want the tag to use.	CLASS="class_name"
Style	The name of the style that you want the heading level tag to use.	STYLE="style_name"

<EMBED>

Complete the values as appropriate and click Submit.

For this option	Type or click	Example
Name	The name of the embedded object.	NAME="object_name"
Hidden	This check box if you don't want the object to appear on the page.	HIDDEN
Source	The URL of the object file.	SRC="URL"
Height	The height used for display of the object in relation to the entire page.	HEIGHT="value"
Width	The width used for display of the object in relation to the entire page.	WIDTH="value"

<OBJECT>

Complete the dialog box options and click Submit.

For this option	Type or click	Example
Class ID	The class ID of an ActiveX control or the name of the object.	CLASSID= "class_ID_string"
Code Type	The path to the code required to run the object.	CODETYPE="path"
Code Base	The URL for the folder that contains the object.	CODEBASE="URL"
Height	The height used for display of the object in relation to the entire page.	HEIGHT="value"
Width	The width used for display of the object in relation to the entire page.	WIDTH="value"
Horizontal	The amount of horizontal space on the left and right of the object display.	HSPACE="value"
Vertical	The amount of vertical space above and below the object display.	VSPACE="value"
Data	The data that initializes the state of the object.	DATA="data_value"
Type	The MIME type for the object.	TYPE="MIME_type"
Name	A name used to refer to an instance of this object in the page. When you have multiple applets in the page, they can communicate with each other using this reference.	NAME="instance_name"
ID	An identifier for this tag. This can be a numeral or a name.	ID="ID_name"
Alignment	An alignment attribute in this list box. Left, Center, and Right are available options.	ALIGN="Left"
Border	A value for the thickness of the border around the object.	BORDER="value"
Class	The name of the class that you want the tag to use.	CLASS="class_name"
Map	The name of the map.	USEMAP="map_name"
Style	The name of the style that you want the heading level tag to use.	STYLE="style_name"

<PARAM>

Complete the values as appropriate and click Submit.

For this option	Type or click	Example
Identification	An identifier for this tag. This can be a numeral or a name.	ID="ID_name"
Type	The MIME type for the object.	TYPE="MIME_type"