Microsoft KB Archive/265185

= HOW TO: Use Two Search Criteria to Retrieve Data in FrontPage 2000 =

Article ID: 265185

Article Last Modified on 10/27/2002

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q265185



IN THIS TASK
SUMMARY
 * Use Two Search Criteria to Retrieve Data



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).
 * 1) 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

Additional query words: ocsso front page

Keywords: kbhowto kbhowtomaster KB265185

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.