Setting the Update Record dialog box options (ColdFusion)

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 (ColdFusion).
• 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 (ColdFusion).
• Add an HTML form to the update page to let users modify the data. For instructions, see Completing the update page block by block (ColdFusion).

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

To set the dialog box options:

1. Select a form from the Submit Values From pop-up menu.
2. In the Data Source pop-up menu, select a connection to the database.
3. Enter your user name and password if applicable.
4. In the Update Table pop-up menu, select the database table that contains the record you are updating.
5. Specify a database column to update, select the form object that will update the column from the Value pop-up menu, select a data type for the form object from the Submit As pop-up menu, and select Primary Key if you want to identify this column as the primary key.

   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.

6. In the After Updating, Go To text box, enter the page to open after the record updates in the table or click the Browse button to browse to the file.
7. Click OK.

Dreamweaver adds a server behavior to the page that lets users update records in a database table by modifying the information displayed in the HTML form and clicking the Submit button.

Related topics

• Completing the update page block by block (ColdFusion)