Adobe Dreamweaver CS4 enables you to easily create master/detail ColdFusion pages. A master page is a page that lists database records and corresponding links for each record. When the user clicks a link, a detail page opens displaying more information about the record.

Requirements

In order to make the most of this article, you need the following software:

Dreamweaver CS4

• Try
• Buy

Prerequisite knowledge

Familiarity with building dynamic sites in Dreamweaver.

Creating a master page

This section describes how to create a master page that lists database records. You can use a dynamic table to list the records on a ColdFusion page.

Before you start, make sure you define a ColdFusion data source for your database. For more information, see Database Connections for ColdFusion Developers in Dreamweaver Help.

To create a master page:

1. In Dreamweaver CS4, create a new ColdFusion page. Choose File > New > ColdFusion, and click Create. A blank ColdFusion page opens in Dreamweaver CS4.

2. Define a recordset for the page.

   In the Bindings panel, click the Plus (+) button, select Recordset (Query), and complete the Recordset dialog box. For more information, click the Help button on the dialog box. If you want to write your own SQL statement, click the Advanced button to open the advanced Recordset dialog box.

   Make sure the recordset contains all the table columns you need to create your dynamic table. The recordset must also include the table column containing the unique key of each record—that is, the record ID column. In Figure 1, the ARTISTID column contains information that uniquely identifies each record.

   

   Figure 1. The ARTISTID column contains information that uniquely identifies each record.

   Typically, the recordset on the master page extracts a few columns from a database table while the recordset on the detail page extracts more columns from the same table to provide the extra detail. For now, though, simply use the default All columns selection.

   The recordset can be defined by the user at runtime. For more information, see Find and display the requested record on the detail page in Dreamweaver Help.

3. Insert a Master Detail Page Set to both display the records on the page and create a detail page (see Figure 2).

   

   Figure 2. Insert a Master Detail Page Set to both display the records on the page.

   If prompted to save the file, save it as test.cfm. The Master Detail Page Set dialog box appears (see Figure 3).

   

   Figure 3. Select a few of the fields for the master page.

   Select a few fields for the master page. Note that you can specify which field will have the link and what column from the recordset will be used in the link. Specify test_detail.cfm for the detail page name, and select whatever fields you want to display for the detail page. Finally click OK.

Viewing the completed pages

After uploading both the master and detail pages to the server, you can open the master page in a browser (see Figure 4).

Figure 4. The master page as it appears in a browser.

After clicking the Donolan link on the master page, the detail page opens with more information about the record (see Figure 5).

Figure 5. The detail page contains more information about the record.

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License

About the author