Operation Manual

585
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
Build a basic results page
When the user clicks the form’s Search button, the search parameters are sent to a results page on the server. The
results page on the server, not the search page on the browser, is responsible for retrieving records from the database.
If the search page submits a single search parameter to the server, you can build the results page without SQL queries
and variables. You create a basic recordset with a filter that excludes records that don’t meet the search parameter
submitted by the search page.
Note: If you have more than one search condition, you must use the advanced Recordset dialog box to define your
recordset (see
“Build an advanced results page” on page 586).
More Help topics
“About search and results pages” on page 583
“Build the search page” on page 584
“Create a detail page for a results page” on page 588
Create the recordset to hold the search results
1 Open your results page in the Document window.
If you don’t have a results page yet, create a blank dynamic page (File > New > Blank Page).
2 Create a recordset by opening the Bindings panel (Window > Bindings), clicking the Plus (+) button, and selecting
Recordset from the pop-up menu.
3 Make sure the simple Recordset dialog box appears.
If the advanced dialog box appears instead, switch to the simple dialog box by clicking the Simple button.
4 Enter a name for the recordset, and select a connection.
The connection should be to a database containing data you want the user to search.
5 In the Table pop-up menu, select the table to be searched in the database.
Note: In a single-parameter search, you can search for records in only a single table. To search more than one table at a
time, you must use the advanced Recordset dialog box and define a SQL query.