Datasheet

Book IX
Chapter 1
Building Master and
Detail Pages
739
7. In the Name column, enter the column name.
You can also click the Dynamic lightning bolt icon and select the column
from the dialog box.
8. Click in the Value column and then click the Dynamic (lightning bolt)
icon.
The Dynamic Data dialog box appears. This is where you select the key
field from the recordset.
9. Expand the recordset, click the key field, and then click OK.
In this case, we selected the empid key field. After you click OK, the
Parameters dialog box displays the new parameter and the code that
places it into the page dynamically, as shown in Figure 1-7.
10. Click OK to close the Parameters dialog box.
The URL field in the Select File dialog box is prepopulated with the new
parameter.
Each dynamic page type has different code that appears because each
programming language uses a slightly different syntax to display a URL
variable dynamically. Fortunately, because Dreamweaver is generating
the code for you, you don’t need to know the syntax differences.
11. Click Choose to close the Select File dialog box.
You return to the Document window. The name of the detail page
appears in the Link field in the Properties inspector. The placeholder for
the dynamic content is now a link.
12. Choose File➪Save to save your changes to the master page.
You now have a complete master page.
Read on to find out how to make the detail page.
Building detail pages
To create a detail page for PHP, ASP, JSP, and ColdFusion page types, follow
these steps:
1. Create a new or PHP, ASP, JSP, or ColdFusion page or open an exist-
ing one.
2. In the Bindings panel, click the plus (+) icon and then select Recordset
(Query) from the menu that appears.
The simple Recordset dialog box appears.
If you want to write your own SQL statements, click the Advanced
button to display the advanced Recordset dialog box.
Developing Master and Detail Pages Block by Block
53_610770-bk09ch01.indd 73953_610770-bk09ch01.indd 739 5/6/10 1:20 PM5/6/10 1:20 PM