|
DBStore is the database function that allows you and your customers to add records from a web page to a website database in real-time. Any record that has been added to your website database via DBStore is instantly available for use in search and query. In addition to any form information that is sent, DBStore can also be used to store the user's IP Address and the date and time of the database post.
Note:The tag names identifying the database and table are different in DBstore than in DBsearch. Make sure you use the correct names. You cannot copy the tags from DBSearch to DBStore.
You must have all of the following fields defined within the<FORM></FORM>tags in your HTML page and make sure that the values are correct and correspond to the fieldnames in your database.
REQUIRED FORM INPUT VALUES
| INPUT |
POST METHOD |
| Opening Tag |
<FORM METHOD="POST" ACTION="/cgi-bin/dbstore.exe"> |
| db_database |
<input type="hidden" name="db_database" value="\database_name.mdb"> |
| db_table |
<input type="hidden" name="db_table" value="table_name"> |
| db_index |
<input type="hidden" name="db_index" value="IndexName"> |
| dbtype |
<input type="hidden" name="dbtype" value="Excel 5.0"> |
| template |
<input type="hidden" name="template" value="\return.htm"> |
| nextpage |
<input type="hidden" name="nextpage" value="/results.htm"> |
| DB_FIELD_ |
<input type="text" name="DB_FIELD_Fieldname"> |
To make a functioning DBStore Form, you must specify a value for each of the following parameters including the database name, path and the table you will be posting data to. You may also specify a return template so that the data posted to the database can be re-displayed on the confirmation page.
db_database
The name and path to the database that will be posted.
db_table
The Table within the database to which the data will be posted.
db_index
Specifies the index field, the field that the database will sort the data by.
dbtype
Specifies the type of the database being stored to (see:Database Types Supported). MDB (Access 95/97) is the default database type and does not require this parameter.
template
This will give the location path and file name of the results/return page. The return template will re-display any data from this post according to the fields you specify on the template. The Template will also display the date and IP Address if the Current Date and IP address capture methods are used. See below for a detailed description.
nextpage
This is the path and file name of the page that is returned upon submission of a successful post. You do not need a nextpage if you are using a template page and vice-versa.
DB_FIELD_
You must have DB_FIELD in front of each fieldname you are posting data to.
ADVANCED FUNCTIONS
| INPUT |
POST METHOD |
| errorpage |
<input type="hidden" name="Error_Page" value="/error.htm"> |
| DB_FIELD_MUST_ |
<input type="text" name="DB_FIELD_MUST_Fieldname"> |
| DB_USER_IP |
<input type="hidden" name="DB_USER_IP_(Fieldname)"> |
| DB_NOW_ |
<input type="hidden" name="DB_NOW_(Fieldname)"> |
| DB_FIELDCOOKIE_ |
<input type="hidden" name="DB_FIELDCOOKIE_(Fieldname)"> |
| DB_FIELDFILE_ |
<input type="hidden" name="DB_FIELDFILE_(Fieldname)" value="/path/datafile.txt"> |
| MAKEPASSWORD |
<input type="hidden" name="MAKEPASSWORD" value="fieldname"> |
errorpage
This is the path and file name of the template page that is returned when there is an error with the database post or any of the "MUST" fields have not been successfully filled in. The errorpage would display the "Must" field names that were not completed. Use of the errorpage is an optional parameter and is not required for a successful DBStore.
(On the errorpage the fieldnames of the empty "Must" fields would be displayed without#* ## *#signs.)
Example:
You did not fill in all the required fields. The fields that were incomplete are:
#*
##FIRST NAME##
##EMAIL ADDRESS##
*#
DB_FIELD_MUST_
If you wish to make a field in your form a "required" field before the post will be accepted, use DB_FIELD_MUST in front of each required fieldname.
Example:DB_FIELD_MUST_YourFieldName
DB_USER_ IP_
Captures the IP Address of the person submitting the form.
DB_NOW_
Stores the date and time that the post was made to the database to the specified field.
DB_FIELDCOOKIE_
Takes the contents of a cookie and stores it to the specified field. This feature is usually used with JavaScript or VBScript form control and cookie functions. We recommend using a memo or other large field type when using this feature.
DB_FIELDFILE_
Takes the contents of a file and stores it to the specified field. We recommend using a memo or other large field type when using this feature.
MAKEPASSWORD
A password is auto-generated and stored in the field you specify. It can be retrieved later by doing a search on the fieldname.
©1995-2001 InfoDial, Inc.
|