DBSEARCH REQUIREMENTS

To set up a dbsearch on a web page, 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.

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 dbtype described below.

tbl
The Table or SQL Query to be used/searched in this database function. For more information on using SQL see: Using SQL.

dbindex(s)
Specifies the index field that the data will be sorted by. The index field will specify the order of the returned records and sort the data in the database table by that field. More than one Index can be specified with commas, as shown above.

template
This will give the location path and file name of the results/return page. See below for a detailed description.

nextpage
This is the path and filename of the page that is shown when there are no records found matching the search. This page will be shown instead of the results/return page.

error template
This page is used instead of the 'nextpage' parameter when there is no data matching the search criteria. The Error Template adds the ability to pass the search data to the template page for re-display.

db type
The "dbtype" input value needs to be used when using a legacy database other than an Access database. To determine the value for this field refer to the legacy database chart.

reverse
A qualifying function of dbindex. Reverses the order of the return so you can have the return results sorted by latest to earliest date, or newest order number to oldest etc. Reverses the return results of ANY fieldname in your database.

Specify Field
Used instead of dbindex. Use the FieldName of the field that you wish to search on and place DB_ in front of it.

multiple fields
Narrows down a search return. For the first field in the search use the FieldName of the field that you wish to search and place DB_ in front of it as above. For each additional field use a DBX_ in front of each FieldName.

Return All
DB_RETURN_ALL makes sure that all records within a field in the database are returned. This can be used with SearchNext and SearchPrev functions as well.

User IP
DB_USER_IP_ Obtains the IP Address of the person submitting the DBSearch and searches the specified field for match(s).

DBCOMP
Makes the search return an exact match. Example if you searched on a field with the DBCOMP tag for "sm" you would be returned a record that had the exact value of "sm" and would not be returned a record that was a partial match like "smith".

dblessthan
Only the numeric values less than or equal to this tag will be returned.

dbgreater
Only the numeric values greater than or equal to this tag will be returned.

RETURNMAX
Specifies the number of returns displayed (up to 50) on your template page.

SearchNext
A 'Forward' or 'Next X' button. Allows you to continue searching for the next records. You would put this code on your template page, the page returned after your initial search. You would also need to have an input for the original field searched with the ##SearchData## tag as the value. You can also use the ReturnMax variable to set or change the amount of records returned.

SearchPrev
A 'Back' or 'Previous X' button. Allows you to search the previous records. You would put this code on your template page, the page returned after your initial search. You would also need to have an input for the original field searched with the ##SearchData## tag as the value. You can also use the ReturnMax variable to set or change the amount of records returned.

SearchData
The SearchData Tag is used to 'carry on' or retain the original search data from the initial search page through each consecutive return page. It reused each time the search is advanced through the records returned.

Single Field Search: Use DB_(fieldname) on the search page instead of dbindex. The tag to retain the original search variables through each consecutive search of the database is
<input type="hidden" name="DB_FIELDNAME" value="##SearchData##">
as shown in the table above.

Multi Field Search: For Multi-Field Searches you use the above ##SearchData## to return the value for the first DB_(fieldname). To return the values for the ensuing DBX_(fieldnames), you need to use the ##SearchDataX## tag:
<input type="hidden" name="DBX_LastName" value="##SearchData1##">
<input type="hidden" name="DBX_MiddleName" value="##SearchData2##">
<input type="hidden" name="DBX_PhoneNumber" value="##SearchData3##">

SAVEAS
SAVEAS allows you to store the result of your search to a text file with a name of your choice. File extensions can be any type of text file like .css, .aspl, .asp, .txt, .js, etc. You can generate a unique (exact date/time based) file name by placing ####. prior to the file extension, ####.asp for example. SAVEAS can also generate an actual portion of the filename. First, assign whatever name you would like to the file, then place ####. exactly prior to the file extension you wish to specify:
open_orders_####.txt for example.

DBEMAIL
The template is emailed to your user, and they are sent to the URL set by DBEMAIL. An example message might be:

Thank you for registering with Our Company, John Doe. Please go to:
http://www.yoursite.com/comegetyourfreebies.asp

WHOFROM
Sets the source email address in DBEMAIL.

WHOTO
Sets the destination email address in DBEMAIL.

SUBJECT
Sets the subject of the email message in DBEMAIL.

EveryXthValue
Inserts HTML commands into a repetitive sequence when building the output using the template. This is useful for applications that need to terminate table rows and start new rows of data output. For example, if you use '4' as the value, the data would be displayed like this: