|
DBModify enables the quick modification of single or multiple record data within a database hosted on your web site. You will need to know how to use the DBSearch feature before using DBModify.
The DBModify command works within a DBSearch and uses the DBModify_(FieldName) tags to enter new/updated values to the records in the database. You would create a form with the current fields you wish to modify in it. You would then submit the updated information to the database.
<FORM METHOD="POST" ACTION="/cgi-bin/dbsearch.exe">
<input type="hidden" name="mdb" value="\mydatabase.mdb">
<input type="hidden" name="tbl" value="MyTable">
<input type="hidden" name="DBCOMP" value="ABS">
<input type="hidden" name="nextpage" value="/path/notfound.htm">
<input type="hidden" name="template" value="\path\updated.htm">
Fieldname: <input type="text" name="DBModify_Fieldname" size="20">
Fieldname2: <input type="text" name="DBModify_Fieldname2" size="20">
<input type="submit" value="Modify Record">
</FORM>
dbupdate.exe is a function which searches a database for a record, and if the record is found, modifies it with user input. If the record is not found, the new information being input by the user is added (posted) to the database.
The DBFF_ variable works in the same way as the DB_ tag does in dbsearch.exe. It specifies the field to find (find field).
<FORM METHOD="POST" ACTION="/cgi-bin/dbupdate.exe">
<input type="hidden" name="mdb" value="\path\filename.mdb">>
<input type="hidden" name="tbl" value="Table1">
<input type="hidden" name="template" value="\path\updated.htm">
Fieldname: <input type="text" name="DBFF_Fieldname" size="20">
<input type="submit" value="Update Record">
</FORM>
©1995-2001 InfoDial, Inc.
|