
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: ...