Skip to Main Content
Adobe® Dreamweaver® CS4 Bible
book

Adobe® Dreamweaver® CS4 Bible

by Joseph Lowery
March 2009
Beginner to intermediate content levelBeginner to intermediate
1321 pages
46h 24m
English
Wiley
Content preview from 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: ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Adobe® Dreamweaver® CS5 Bible

Adobe® Dreamweaver® CS5 Bible

Joseph W. Lowery
Dreamweaver® CS3 Bible

Dreamweaver® CS3 Bible

Joseph W. Lowery

Publisher Resources

ISBN: 9780470382523Purchase book