Operation Manual

581
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
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.
7 Bind the recordset columns to the detail page by selecting the columns in the Bindings panel (Window > Bindings)
and dragging them onto the page.
After uploading both the master and detail pages to the server, you can open the master page in a browser. After
clicking a detail link on the master page, the detail page opens with more information about the selected record.
More Help topics
“Set up a testing server” on page 43
Find a specific record and display it on a page (ASP)
You can add a server behavior that finds a specific record in a recordset so that you can display the record data on the
page. The server behavior is only available when using the ASP server model.
1 Create a page that has the following prerequisites:
• A record ID contained in a URL parameter passed by another page to the current page. You can create URL
parameters on the other page with HTML hyperlinks or with an HTML form. For more information, see
“Using
forms to collect information from users” on page 623.
• A recordset defined for the current page. The server behavior extracts the record details from this recordset. For
instructions, see
“Define a recordset without writing SQL” on page 536 or “Define an advanced recordset by writing
SQL” on page 538.
• Recordset columns bound to the page. The specific record must be displayed on the page. For more information,
see
“Make text dynamic” on page 550.
2 Add the server behavior to find the record specified by the URL parameter by clicking the Plus (+) button on the
Server Behaviors panel (Window
> Server Behaviors) and selecting Recordset Paging > Move to Specific Record.
3 In the Move To Record In pop-up menu, select the recordset you defined for the page.
4 In the Where Column pop-up menu, select the column that contains the value passed by the other page.
For example, if the other page passes a record ID number, select the column containing record ID numbers.
5 In the Matches URL Parameter box, enter the name of the URL parameter passed by the other page.
For example, if the URL the other page used to open the detail page is id=43, enterid in the Matches URL Parameter box.
6 Click OK.
The next time the page is requested by a browser, the server behavior will read the record ID in the URL parameter
passed by the other page and move to the specified record in the recordset.