Adobe Dreamweaver CC 2015 - Manual (Page 646)

639
Building applications visually
Last updated 6/3/2015
5 If desired, pass existing page parameters to the detail page by selecting the URL Parameters or Form Parameters
options.
6 Click OK.
A special link surrounds the selected text. When the user clicks the link, the Go To Detail Page server behavior
passes a URL parameter containing the record ID to the detail page. For example, if the URL parameter is called id
and the detail page is called customerdetail.asp, the URL looks something like the following when the user clicks on
the link:
http://www.mysite.com/customerdetail.asp?id=43
The first part of the URL, http://www.mysite.com/customerdetail.asp, opens the detail page. The second part,
?id=43, is the URL parameter. It tells the detail page what record to find and display. The term id is the name of the
URL parameter and 43 is its value. In this example, the URL parameter contains the record’s ID number, 43.
Find and display the requested record on the detail page
In order to display the record requested by the master page, you must define a recordset to hold a single record and bind
the recordset columns to the detail page.
1 Switch to the detail page. If you don’t have a detail page yet, create a blank page (File > New).
2 In the Bindings panel (Window > Bindings), click the Plus (+) button and select Recordset (Query) or DataSet
(Query) from the pop-up menu.
The simple Recordset or DataSet dialog box appears. If the advanced dialog box appears instead, click Simple.
3 Name the recordset, and select a data source and the database table that will provide data to your recordset.
4 In the Columns area, select the table columns to include in the recordset.
The recordset can be identical to or different from the recordset on the master page. Usually a detail page recordset
has more columns to display more detail.
If the recordsets are different, make sure the recordset on the detail page contains at least one column in common
with the recordset on the master page. The common column is usually the record ID column, but it can also be the
join field of related tables.
To include only some of the table’s columns in the recordset, click Selected and choose the desired columns by
Control-clicking (Windows) or Command-clicking (Macintosh) them in the list.
5 Complete the Filter section as to find and display the record specified in the URL parameter passed by the master
page:
• From the first pop-up menu in the Filter area, select the column in the recordset containing values that match
the value of the URL parameter passed by the master page. For example, if the URL parameter contains a record
ID number, select the column containing record ID numbers. In the example discussed in the previous section,
the recordset column called CODE contains the values that match the value of the URL parameter passed by the
master page.
• From the pop-up menu beside the first menu, select the equal sign (it should already be selected).
• From the third pop-up menu, select URL Parameter. The master page uses a URL parameter to pass information
to the detail page.
• In the fourth box, enter the name of the URL parameter passed by the master page.
6 Click OK. The recordset appears in the Bindings panel.