Setting the Delete Record dialog box options (ColdFusion)

Setting the Delete 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 delete a record in a database table when they click the Submit button on the form.

To set the dialog box options:

  1. In the First Check If Variable Is Defined pop-up menu, select Primary Key Value.

    If you want to check a variable other than the variable identifying the record to delete, then select the variable, and enter its name.

    Dreamweaver checks to see if that variable is defined.

  2. In the Data Source pop-up menu, select a connection to the database.
  3. Enter your user name and password.
  4. In the Table pop-up menu, select the database table containing the records to delete.
  5. In the Primary Key Column pop-up menu, select a key column to identify the record in the database table.

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

  6. In the Primary Key Value pop-up menu, select the variable identifying the record to delete, and then enter its name.
  7. In the After Deleting, Go To text box, enter the page to open after the record is deleted from the database table or click the Browse button to browse to the file.
  8. Click OK.

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

Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly
Building ColdFusion Applications Rapidly
Building ASP.NET Applications Rapidly
Building ASP and JSP Applications Rapidly