Operation Manual

592
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
Dreamweaver adds both an HTML form and an Insert Record server behavior to your page. The form objects are laid
out in a basic table, which you can customize using the Dreamweaver page design tools. (Make sure all the form objects
remain within the form’s boundaries.)
To edit the server behavior, open the Server Behaviors panel (Window > Server Behaviors) and double-click the Insert
Record behavior.
Building an update record page
About record update pages
Your application can contain a set of pages that lets users update existing records in a database table. The pages
normally consist of a search page, a results page, and an update page. The search and results page let users retrieve the
record and the update page lets users modify the record.
Search for the record to update
When users want to update a record, they must first find that record in the database. Accordingly, you need a search
and a results page to work with the update page. The user enters search criteria in the search page and selects the record
on the results page. When the user clicks the record on the results page, the update page opens and displays the record
in an HTML form.
More Help topics
“Building search and results pages” on page 583
Create links to the update page
After creating the search and results pages, you create links on the results page to open the update page. You then
modify the links to pass the IDS of the records the user selects. The update page uses this ID to find the requested
record in the database and display it.
You use the same process to open the update page and pass a record ID that you do to open a detail page and pass a
record ID. For more information, see
“Create links to the detail page” on page 578.
More Help topics
“URL parameters” on page 624
Retrieve the record to update
After the results page passes a record ID to the update page identifying the record to update, the update page must read
the parameter, retrieve the record from the database table, and store it temporarily in a recordset.
1 Create a page in Dreamweaver and save it.
The page will become your update page.
2 In the Bindings panel (Window > Bindings), click the Plus (+) button and select Recordset.
If the advanced dialog box appears, click Simple. The advanced dialog box has a text area to enter SQL statements; the
simple one does not.