More Database Options

Return to Using the FrontPage Database Wizards

More Options Window

You can: Modify the message to be displayed if your table is empty. Limit the number of results to be displayed on a page. Set up criteria for which data will be displayed (The "Criteria..." button allows you to set the criteria for the search of the database.  If you do not set any criteria the results wizard will display all records in the database).    Sort the results.

Criteria Window

If you click on the "Add..." button you can designate search criteria that will limit the records displayed to those records matching the search criteria.

Criteria Selection

This is the window to let you Add criteria to your data search.  You can select different comparison modes for each field of the data base. To set criteria, tell the wizard what field name you wish to search, how you wish it to match the value you set (this image shows Equals), and the value you want to match.  A key component of matching values is the "Use this search form field" checkbox under the "Value:" field.  If this box is checked the wizard is expecting to receive a value from a form field.  That is, that you have set up a form field on a web page and are sending whatever is in that field to the page with this wizard on it.  In the "Value:" field you can type in the value you want to match.  The default value will be the same name as the field name.  If you name your form fields that same as your database fields this works very well.  If you want to search for a specific value and don't use a search form field you need to uncheck the "Use this search form field" box. You can put criteria together with either AND or OR links.

Sort Order

Here, you can add which fields to sort by, and in which order to sort.