Append Command

Append?db=DatabaseName&field1=xx&field2=xx

Appends a new record with the specified field values to the end of a database.

To add new records to a database, use a web browser to link to a URL containing the Append command (alternately, you may embed an [Append] context into a template). Whenever WebCatalog receives an Append command, it immediately adds a new record to the end of the specified database given the named field values.

Example (normally you would link to a URL or form containing the following information):

http://yourserver.com/xx.tpl?command=Append&db=SomeDatabase.db&name=Grant&address=1492%20Somewhere%20Lane&zip=90000

Try It!

The database "SomeDatabase.db" is opened, and a new record is added to the end with fieldname "name" being set to "Grant", fieldname "address" being set to "1492 Somewhere Lane", and fieldname "zip" being set to "90000". The page sent back to the browser will be xx.tpl

Any fieldnames that do not exist in the database are ignored, and any fields you do not specify are left blank in the new record. You may specify a relative or full URL to the database file, as in "/WebCatalog/Folder/SomeDatabase.db" or "../SomeDatabase.db". The path to the database is always relative to the template URL, so if the database is in the same folder as the template the path would be "SomeDatabase.db", and if the database were one folder up then the path would be "../SomeDatabase.db".

Note: You may force the visitor to enter something into a field by using the RequiredFields parameter in the URL. Setting RequiredFields=field1+field2+field3 will display an error message if the visitor forgets to enter some text into any of those 3 fields. RequiredFields works for all commands, not just this one.

Here are some other ways to send the same command:

HTML Source

Description

<a href="/WebCatalog/WebCatalog.acgi
?command=Append&template=xx.tpl&db=SomeDatabase.db
&name=Grant&address=1234%20Somewhere">
Hyperlink to WebCatalog CGI

<a href="xx.tpl?command=Append&db=SomeDatabase.db&
name=Grant&address=1234%20Somewhere">
Hyperlink to WebCatalog plugin

<form method="POST" action="/WebCatalog/WebCatalog.acgi">
<input type="hidden" name="command" value="Append">
<input type="hidden" name="template" value="xx.tpl">
<input type="hidden" name="db" value="SomeDatabase.db">
<input name="name">
<input name="address">
<input type="submit">
</form>

Form-based command to CGI
(notice you must specify a template)

<form method="POST" action="xx.tpl">
<input type="hidden" name="command" value="Append">
<input type="hidden" name="db" value="SomeDatabase.db">
<input name="name">
<input name="address">
<input type="submit">
</form>

Form-based command to plugin
(notice the template is part of the action)

HTML Source	Description
<a href="/WebCatalog/WebCatalog.acgi ?command=Append&template=xx.tpl&db=SomeDatabase.db &name=Grant&address=1234%20Somewhere">	Hyperlink to WebCatalog CGI
<a href="xx.tpl?command=Append&db=SomeDatabase.db& name=Grant&address=1234%20Somewhere">	Hyperlink to WebCatalog plugin
<form method="POST" action="/WebCatalog/WebCatalog.acgi"> <input type="hidden" name="command" value="Append"> <input type="hidden" name="template" value="xx.tpl"> <input type="hidden" name="db" value="SomeDatabase.db"> <input name="name"> <input name="address"> <input type="submit"> </form>	Form-based command to CGI (notice you must specify a template)
<form method="POST" action="xx.tpl"> <input type="hidden" name="command" value="Append"> <input type="hidden" name="db" value="SomeDatabase.db"> <input name="name"> <input name="address"> <input type="submit"> </form>	Form-based command to plugin (notice the template is part of the action)