HOW TO: Use Two Search Criteria to Retrieve Data in FrontPage 2000 (265185)

SUMMARY

This article describes how to use more than one criterion in a Microsoft FrontPage 2000 search form to generate results from a database.

back to the top

Use Two Search Criteria to Retrieve Data

To use two search criteria to retrieve data from the Northwind sample database, follow these steps:

1. Start FrontPage.
2. On the File menu, point to New, and the click Web.
3. Select a Web site and location for the web, and then click OK.
4. On the File menu, point to New, and the click Page.
5. Click Normal Page, and then click OK.
6. On the Insert menu, point to Database, and then click Results.
7. Click Use a sample database connection (Northwind), and then click Next.
8. Click Record source, select Employees as the record source, and then click Next.
9. Click More Options.
10. Click Criteria.
11. Click Add.
12. In the Field Name box, click Title.
13. In the Comparison box, click Contains, and then click OK twice.
14. Click More Options.
15. Click Criteria.
16. Click Add.
17. In the Field Name box, click City.
18. In the Comparison box, click Contains, and then click OK twice.
19. Click Defaults.
20. Select Title, and then click Edit.
21. Type % in the Value box, and then click OK.
22. Select City, and then click Edit.
23. Type % in the Value box, and then click OK three times.
24. Click Next twice, and then click Finish.
25. On the File menu, click Save As.
26. Type title in the File name box, and then click Save.
    
    NOTE: The default file type should be Active Server Pages (*.asp).
27. On the File menu, click Preview in Browser.
    
    Note that you can enter either a title (for example, Sales Representative), or a city (for example, Seattle).

back to the top