Completing the update page in one operation (ColdFusion)
An update page has three building blocks:
- A filtered recordset to retrieve the record from a database table (see Retrieving the record to update (ColdFusion))
- An HTML form to let users modify the records data
- An Update Record server behavior to update the database table
You can add the final two building blocks of an update page in a single operation using the Record Update Form application object. The application object adds both an HTML form and an Update Record server behavior to the page.
Before you can use the application object, your web application must be able to identify the record to update, and your update page must be able to retrieve it. See Searching for the record to update (ColdFusion), Creating the links to open the update page (ColdFusion), Creating a URL parameter for update links (ColdFusion) and Retrieving the record to update (ColdFusion).
After the application object places the building blocks on the page, you can use the Dreamweaver design tools to customize the form to your liking, or the Server Behaviors panel to edit the Update Record server behavior.
The update page can contain only one record-editing server behavior at a time. For example, you cannot add an Insert Record or a Delete Record server behavior to the update page.
To build the update page with the Record Update Form application object:
- Open the page in Design view, then select Insert > Application Objects > Update Record > Record Update Form Wizard.
The Record Update Form dialog box appears.
- Complete the dialog box.
For instructions, see Setting the Record Update Form dialog box options.
- Click OK.
The application object adds both an HTML form and an Update 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 forms boundaries.)
To edit the server behavior, open the Server Behaviors panel (Window > Server Behaviors) and double-click the Update Record behavior.
- Completing the update page block by block (ColdFusion)