Adobe® Dreamweaver® CS4 Bible

812

Part IV

Incorporating Dynamic Data

After entering Live Data view, you can test a variety of different records without reopen-

ing the Live Data Settings dialog. In the URL Parameter field found on the Live Data tool-

bar, change the URL parameter’s current value and press Enter (Return). If you enter a value not found

in the data source, Dreamweaver displays an error indicating that it cannot display the page.

To test your master-detail application, save both pages and then preview the master page in the

browser. When you select the link to the detail page, you should see your chosen record.

Filtering a detail page recordset in Advanced mode

Sometimes you need to define a more complex recordset than is possible in the simple Recordset

dialog box. You can effectively add the same filter-by-URL-parameter argument for such recordsets

in the advanced Recordset dialog box by altering the SQL statement. Filtering in a SQL statement is

handled by the

WHERE clause.

To create a detail page filter, you declare a variable and add a

WHERE clause referencing that vari-

able. The runtime value portion of the variable is different for each server model. Assume that you

want to declare a variable called

theBrand, and the field is named Brand. In the Variables section

of the Advanced Recordset dialog box, click the Add (+) button and then enter the following values,

according to your server model: ...