Datasheet

Developing Master and Detail Pages Block by Block
700
Depending on your dynamic page type, the Recordset dialog box may
appear slightly different from the one in Figure 1-7. ColdFusion, in partic-
ular, calls the Connection field a data source and includes the Username
and Password fields for the database. However, these differences don’t
change the following steps.
6. Select which columns will provide the record data to display.
To use all columns, select All; otherwise, choose Selected and Ctrl+click
(Windows) or Ô+click (Mac) in the list to indicate which columns you
want to use.
Typically, your detail page uses more columns than your master page.
You want the recordset for your detail page to contain at least one
column (generally the record ID column) that matches the column that
you use for the master page.
7. Complete the Filter sections as follows:
• The first Filter field: Select the database column name that contains
values to match against the URL parameter. You use the filter to find
and display the record specified by the URL parameter passed from
the master page.
• The second Filter field: Select the equals (=) symbol, if it’s not
already selected. This requires the fields to be equal, which they
must be to display only the record that is detailed.
• The third Filter field: Select the URL parameter.
• The fourth Filter field: Enter the name of the URL parameter that
you want the master page to pass to the detail page.
The recordset now returns only the data for the employee who’s been
selected on the master page.
8. Click the Test button.
The Test Value dialog box appears.
9. Enter a value in the Test Value field and click OK.
This value represents which detail record displays. This test helps you
check that the detail page brings back the data you expect.
A table displaying data from the recordset appears.
10. Click OK.
The Test SQL Statement window closes.
11. In the Recordset dialog box, click OK.
Figure 1-8 shows the recordset in the Bindings panel of the detail page.
52_781428 bk09ch01.qxp 6/19/06 11:46 AM Page 700