Chapter 20. Work with Data-Driven Pages
Create a Search Interface
You can allow your users to search for records in your database by creating a form that allows users to enter their search criteria and a page to process the search by querying the database using the form's data. The search page is usually a fairly simple form, often nothing more than a single text field and a button.
The results page needs to contain a recordset. In the Recordset builder, you can add a filter. When Dreamweaver creates the SQL statement, the filter becomes the WHERE clause. You can specify where the value for the filter is coming from; in the case of forms, it is a Form Variable, with a name equal to the name from the form field. You can test to see if the form field's ...
Get Master Visually®: Dreamweaver® CS4 and Flash® CS4 Professional now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
