|
You can select and delete specific records or any records matching your specific criteria. When a record is deleted the values of the deleted record can be transported to a template page for use in a repost to another database, and modifications can be made to the data to be re-posted.
Required Form Input Values
| INPUT |
POST METHOD |
GET METHOD |
| Form Tag |
<FORM METHOD="POST" ACTION="/cgi-bin/dbdelete.exe"> |
/cgi-bin/dbdelete.exe |
| mdb |
<input type="hidden" name="mdb" value="\path\filename.mdb"> |
mdb=\path\filename.mdb |
| tbl |
<input type="hidden" name="tbl" value="Table1"> |
tbl=Table1 |
| DB type |
<input type="hidden" name="dbtype" value="See Chart"> |
dbtype=See Chart |
| template |
<input type="hidden" name="template" value="\return.htm"> |
template=\return.htm |
| nextpage |
<input type="hidden" name="nextpage" value="/noresult.htm"> |
nextpage=/noresult.htm |
| one field |
<input type="text" name="DB_Fieldname"> |
DB_Fieldname=value |
| multi-field |
<input type="text" name="DBX_Fieldname"> |
DBX_Fieldname=value |
mdb
The name and path of the database referenced with this command. If you wish to use a type of database other than MS Access use the legacy database chart.
tbl
The Table to be used in this database function.
DB type
The "dbtype" input value needs to be used when using a legacy database other than an Access 95 or 97 database. To determine the value for this field refer to the legacy database chart.
dbindex
Specifies the index field. The index field will return the records and sort the data by that field.
template
This will give the location/path and file name of Data Return Template. All the field values of the record selected to be deleted can be passed to the template page after deletion.
nextpage
This is the path and file name of the page to returned after the record has been deleted.
Single Field Delete
To delete a record based on a single/specific field you will use the same code as a single field search (DB_thefieldname).
Multi-Field Delete
To delete record based on the input of two or more fields you will use the same code as a multi field search (DBX_thefieldname).
©1995-2001 InfoDial, Inc.
|