|
Building a multiple-parameter search feature
This article describes how to give users the ability to conduct database searches with two or more different search words, or "search parameters." The first half of the article outlines how to generate search results based on more than one search parameter. If you want to generate search results based on a single search parameter, see the following article: Building a simple database search feature.
Here are the tasks to complete to generate search results based on multiple parameters:
- Getting the search parameters from the user
- Placing the search parameters in SQL variables
- Defining the columns of the recordset
- Including records based on the equality of two values
- Including records based on the likeness of two values
- Including records based on a range of values
- Including records based on a combination of search conditions
The second half of this article outlines the most basic way to display the search results, if any. If you think you'll need more than one page to display the results, see Displaying results on multiple pages.
Here are the tasks to complete to display the search results:
- Adding an HTML table to the results page
- Adding dynamic content to the HTML table
- Applying a repeat region to the HTML table
- Customizing the table's appearance
 |
 |
|
|
 |
29 January 2001 |
|
 |
columns, combine, condition, database, define, display, equal, likeness, multiple, parameter, range, record, recordset, search, value |
|
 |
9889 |
 |
|
|
|
