If the search page submits more than one search parameter to the server, then 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 Searching with only one search parameter). |
If the simple dialog box appears instead, switch to the advanced dialog box by clicking the Advanced button.
The connection should be to a database containing data you want the user to search.
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 Creating an advanced recordset by writing SQL.
For help on SQL syntax, see SQL Primer.
In the following ASP example, the HTML form on the search page uses the GET
method and contains one text field called "LastName" and another called "Department".
In ColdFusion, the runtime values would be #LastName#
and #Department#
. In JSP, the runtime values would be request.getParameter("LastName")
and request.getParameter("Department")
.
The default values simulate the values that would otherwise have been returned from the search page. Click OK to close the test recordset.
Dreamweaver inserts the SQL query in your page.
The next step is to display the recordset on the results page. For more information, see Displaying the results.