Operation Manual

593
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
3 Name the recordset and specify where the data you want to update is located using the Connection and Table
pop-up menus.
4 Click Selected, and select a key column (usually the record ID column) and the columns that contain the data to be
updated.
5 Configure the Filter area so that the value of your key column equals the value of the corresponding URL parameter
passed by the results page.
This kind of filter creates a recordset that contains only the record specified by the results page. For example, if your
key column contains record ID information and is called PRID, and if the results page passes the corresponding record
ID information in the URL parameter called
id, the Filter area should look like the following example:
6 Click OK.
When the user selects a record on the results page, the update page generates a recordset containing only the selected
record.
Complete the update page block by block
An update page has three building blocks:
• A filtered recordset to retrieve the record from a database table
• An HTML form to let users modify the record’s data
• An Update Record server behavior to update the database table
You can add the final two basic building blocks of an update page separately using the form tools and the Server
Behaviors panel.
More Help topics
“Retrieve the record to update” on page 592
“Creating web forms” on page 626
Add an HTML form to an update page
1 Create a page (File > New > Blank Page). This becomes your update page.
2 Lay out your page using the Dreamweaver design tools.
3 Add an HTML form by placing the insertion point where you want the form to appear and selecting Insert >
Form
> Form.
An empty form is created on the page. You may have to enable Invisible Elements (View > Visual Aids > Invisible
Elements) to see the form’s boundaries, which are represented by thin red lines.
4 Name the HTML form by clicking the <form> tag at the bottom of the Document window to select the form,
opening the Property inspector (Window
> Properties), and entering a name in the Form Name box.
You don’t have to specify an action or method attribute for the form to tell it where and how to send the record data
when the user clicks the Submit button. The Update Record server behavior sets these attributes for you.