Using the Database Results Wizard in FrontPage 2002 for Information Filtering
In Microsoft FrontPage® version 2002, the Database Results Wizard enables you to filter database results to display only the records that match the criteria you set. When the page is browsed, only matching records are displayed. You can sort records as well.
If your web site doesn’t have database functionality already, you need to add it (see “Using the Database Interface Wizard”).
To use the Database Results Wizard to help you build a query to filter database results on your Web site using FrontPage 2002, do the following:
- On a page with an existing database results region (such as results_page.asp), right-click the database results region, and then click Database Results Properties. The Database Results Wizard starts.
- Click Next to get to Step 3 of the wizard.
- In Step 3 of the wizard, click More Options, click Criteria, and then click Add.
- In the Field name box, select the field that contains the values you want to look for.
For example, from a database of products, you could select the ReorderLevel field.
- In the Comparison box, select the type of comparison you want to perform.
For example, to filter for all products reordered when stock is zero, you would select Equal in the Comparison box.
- In the Value area, enter the value that you want to filter on.
For example, to display all products reordered when stock is zero, you would enter “0” in the Value box.
- Clear the Use this search form field check box.
- If you're finished specifying criteria, click OK three times to close criteria setup and continue using the wizard.
- To continue to build your query, select And or Or in the And/Or box, and then click OK. In the Criteria dialog box, click Add, and repeat steps 3 through 6 of this procedure. When you have finished, click OK.
- To exit the wizard, click Next twice and then Finish and save the page.
More information
For more information about Database Results Wizard, see Microsoft FrontPage 2002 Help.
