Build an advanced results page – Adobe Dreamweaver CC 2015 User Manual
Page 652
645
Building applications visually
Last updated 6/3/2015
For example, suppose you want to create a recordset that includes only adventure trips to a specific country. Assume
you have a column in the table called TRIPLOCATION. Also assume the HTML form on your search page uses the
GET method and contains a menu object called Location that displays a list of countries. The following example
shows how your Filter section should look:
5
(Optional) Click Test, enter a test value, and click OK to connect to the database and create an instance of the
recordset.
The test value simulates the value that would otherwise have been returned from the search page. Click OK to close
the test recordset.
6
If you’re satisfied with the recordset, click OK.
A server-side script is inserted on your page that checks each record in the database table when it runs on the server.
If the specified field in a record meets the filtering condition, the record is included in a recordset. The script builds
a recordset that contains only the search results.
The next step is to display the recordset on the results page. For more information, see .
Build an advanced results page
If the search page submits more than one search parameter to the server, you must write a SQL query for the results
page and use the search parameters in SQL variables.
Note: If you have only one search condition, you can use the simple Recordset dialog box to define your recordset (see ).
1
Open the results page in Dreamweaver, and then create a recordset by opening the Bindings panel (Window >
Bindings), clicking the Plus (+) button, and selecting Recordset from the pop-up menu.
2
Make sure the advanced Recordset dialog box appears.
The advanced dialog box has a text area to enter SQL statements. If the simple dialog box appears instead, switch to
the advanced dialog box by clicking the Advanced button.
3
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.
4
Enter a Select statement in the SQL text area.
Make sure the statement includes a WHERE clause with variables to hold the search parameters. In the following
example, the variables are called varLastName and varDept:
SELECT EMPLOYEEID, FIRSTNAME, LASTNAME, DEPARTMENT, EXTENSION FROM EMPLOYEE ¬
WHERE LASTNAME LIKE 'varLastName' ¬
AND DEPARTMENT LIKE 'varDept'
To reduce the amount of typing, you can use the tree of database items at the bottom of the advanced Recordset
dialog box. For instructions, see .
For help on SQL syntax, see the SQL primer at
.
5
Give the SQL variables the values of the search parameters by clicking the Plus (+) button in the Variables area and
entering the variable’s name, default value (the value the variable should take if no run-time value is returned), and
run-time value (usually a server object holding a value sent by a browser, such as a request variable).