Datasheet

Book IX
Chapter 1
Building Master and
Detail Pages
Developing Master and Detail Pages Block by Block
699
12. Save your changes to the master page.
You now have a complete master page.
Read on to find out how 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 open an existing PHP, ASP, JSP, or ColdFusion page.
2. In the Bindings panel, click the plus (+) button and 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.
3. In the Name text box, enter a name for your recordset.
You can use only letters, numbers, and underscores in the name.
4. Select a database connection for obtaining the data that you want to
display.
5. Select a table name for obtaining the data that you want to display.
After you select a table name, the database columns appear in the
Columns list. For example, Figure 1-7 shows the columns for the
Employee table (see Table 1-1).
Figure 1-7:
The
Recordset
dialog
box after
selecting a
database
table.
52_781428 bk09ch01.qxp 6/19/06 11:46 AM Page 699