Accessibility
 
Home > Products > UltraDev > Support > Building Common Applications
Dreamweaver UltraDev Icon Macromedia Dreamweaver UltraDev Support Center - Building Common Applications
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

Charles Nadeau

Charles Nadeau is a lead technical writer on the Dreamweaver documentation team.


29 January 2001

columns, combine, condition, database, define, display, equal, likeness, multiple, parameter, range, record, recordset, search, value

9889