Creating master and detail ColdFusion pages
Created
22 December 2008
Requirements
Prerequisite knowledge
Familiarity with building dynamic sites in Dreamweaver.
User level
Intermediate
Required products
- Dreamweaver (Download trial)
Note: This tutorial was written for Creative Suite 4. Although the screenshots may differ from what you see on your screen, the content is still valid for Creative Suite 5.
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.
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 (CS4) / Database Connections for ColdFusion Developers (CS5) in Dreamweaver Help.
To create a master page:
- In Dreamweaver CS4, create a new ColdFusion page. Choose File > New > ColdFusion, and click Create. A blank ColdFusion page opens in Dreamweaver CS4.
- 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.
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 (CS4) / Find and display the requested record on the detail page (CS5) in Dreamweaver Help.
- Insert a Master Detail Page Set to both display the records on the page and create a detail page (see Figure 2).
If prompted to save the file, save it as test.cfm. The Master Detail Page Set dialog box appears (see Figure 3).
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).
After clicking the Donolan link on the master page, the detail page opens with more information about the record (see Figure 5).
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License
More Like This
- Beginner's guide to databases
- Managing multiple subscriptions in PHP
- Building a subscribe/unsubscribe app in PHP with Dreamweaver CS3
- Which server-side technology should I choose?
- Creating user-defined functions for ColdFusion 8 in Dreamweaver CS4
- Creating a ColdFusion upload page in Dreamweaver CS4
- Creating custom server behaviors and Dreamweaver extensions
- Exchanging data using the Spry framework for Ajax and PHP
- Adding database-driven shipping charge functionality to an online store
- SQL primer for Dreamweaver users
Tutorials and samples |
| 04/23/2012 | Resolution/Compatibility/liquid layout |
|---|---|
| 04/20/2012 | using local/testing server with cs5 inserting images look fine in the split screen but do not show |
| 04/18/2012 | Ap Div help |
| 04/23/2012 | Updating |
