This section describes how to create a 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 database connection for the site. For more information, see "Database Connections for ColdFusion Developers" in Dreamweaver Help.

To create a master page:

1	In Dreamweaver MX, create a new ColdFusion page.
	To create a new page, choose File > New > Dynamic, select ColdFusion, and click Create.
	A blank ColdFusion page opens in Dreamweaver MX.
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 the following example, the CODE column contains information that uniquely identifies each record.
	The recordset can be defined by the user at runtime. For more information, see "Building Pages that Search Databases" in Dreamweaver Help.
3	Insert a dynamic table to display the records on the page.
	Place the insertion point where you want the dynamic table to appear on the page, and click the Dynamic Table icon on the Application tab of the Insert bar.
	The Dynamic Table dialog box appears.
4	Complete the Dynamic Table dialog box and click OK.
	Dreamweaver MX inserts a dynamic table on the page.
	If you need help completing the Dynamic Table dialog box, click the Help button on the dialog box.
5	If you want, delete the dynamic table column containing the record IDs.
	If you don't want to show record IDs to users, you can delete the column from the dynamic table. Click anywhere on the page to move the focus to the page. Move the cursor near the top of the column in the dynamic table until a small down-arrow appears, then click to select the table column. Press the Delete key to delete the column from the table.