Adobe 38040334 User Guide - Page 633

DREAMWEAVER CS3 626 User Guide See also "About search and results pages" on page 624 "Build the search page (ColdFusion, ASP, JSP, PHP)" on page 624 "Create a detail page for a results page (ColdFusion, ASP, JSP, PHP)" on page 629 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. 6 To include only some of the table's columns in the recordset, click Selected and select the desired columns by Control-clicking (Windows) or Command-clicking (Macintosh) them in the list. You should include only the columns containing information you want to display on the results page. Leave the Recordset dialog box open for now. You'll use it next to retrieve the parameters sent by the search page and create a recordset filter to exclude records that don't meet the parameters. Create the recordset filter 1 From the first pop-up menu in the Filter area, select a column in the database table in which to search for a match. September 4, 2007