Datasheet

Developing Master and Detail Pages Block by Block
696
Creating the master page
To create a dynamic master page, follow these steps:
1. Create a page and define a recordset.
Turn to Book VIII, Chapter 1 to find out how to define a recordset.
The Recordset dialog box varies slightly between dynamic page types.
Specifically, ColdFusion calls the database connection a data source and
includes optional Username and Password fields for the database. The
dialog box also has a button to access ColdFusion components. The rest
of the dialog box works exactly the same as the dialog box for other
development code types.
2. In the Document window, place the insertion point where you want
the records to appear on the page.
3. Choose Insert➪Application Objects➪Dynamic Data➪Dynamic Table.
The Dynamic Table dialog box opens, as shown in Figure 1-4.
4. From the Recordset drop-down list, select the name of the recordset
that you want to appear on the master page.
For the example, we selected the EmployeeRecordset.
5. Specify the number of records that you want to show at one time on
the master page.
In the example, we wanted to show 10 records at a time.
6. (Optional) Specify border, cell padding, and cell spacing.
7. Click OK to close the dialog box.
The master page is created.
Figure 1-4:
The
Dynamic
Table dialog
box for the
Employee
Recordset.
52_781428 bk09ch01.qxp 6/19/06 11:46 AM Page 696