Setting the Update Record dialog box options (ASP and JSP)

The purpose of this dialog box is to add a server behavior to a page containing an HTML form so that users can update a record in a database table when they click the Submit button on the form.

Before starting, you must complete the following tasks:

• Build one or more pages that let the user find the record they want to update. For more information, see Searching for the record to update (ASP and JSP).
• Add logic to the update page allowing it to retrieve the user’s chosen record from the database in preparation for updating. For instructions, see Retrieving the record to update (ASP and JSP).
• Add an HTML form to the update page to let users modify the data. For instructions, see Completing the update page block by block (ASP and JSP).

With these prerequisites in place, you can complete the Update Record dialog box.

To set the dialog box options:

1. In the Connection pop-up menu, select a connection to the database.

   Click the Define button if you need to define a connection.

2. In the Table to Update pop-up menu, select the database table that contains the record you are updating.
3. In the Select Record From pop-up menu, specify the recordset that contains the record displayed in the HTML form.
4. In the Unique Key Column pop-up menus, select a key column (usually the record ID column) to identify the record in the database table.

   Select the Numeric option if the value is a number. A key column usually accepts only numeric values, but sometimes it accepts text values.

5. In the After Updating, Go To text box, enter the page to open after the record has been updated in the table.
6. In the Get Values From pop-up menu, select the HTML form used to edit the record data.

   Dreamweaver automatically selects the first form on your page.

7. Specify a database column to update, select the form object that will update the column from the Value pop-up menu, and then select a data type for the form object from the Submit As pop-up menu.

   The data type is the kind of data the column in your database table is expecting (text, numeric, Boolean checkbox values).

   Repeat the procedure for each form object in your form.

8. Click OK.

Dreamweaver adds a server behavior to the page that lets users update records in a database table by clicking the Submit button on the form.