Setting the Delete 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 delete 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 delete. For more information, see Identifying the record to delete (ASP and JSP).
• Add logic to the delete page allowing it to retrieve the user’s chosen record from the database in preparation for deletion. For instructions, see Retrieving the record to delete (ASP and JSP).
• Display the record on the page so the user can view it before deleting it. For instructions, see Displaying the data to be deleted (ASP and JSP).
• Add an HTML form with a Submit button to the delete page to send the delete command to the server. For instructions, see Sending the delete command to the server (ASP and JSP).

With these prerequisites in place, you can complete the Delete 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 Delete from Table pop-up menu, select the database table that contains the record to delete.
3. In the Select Record From pop-up menu, specify the recordset that contains the record to delete.
4. In the Unique Key Column pop-up menu, select a key column (usually the record ID 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.

5. In the Delete By Submitting pop-up menu, specify the HTML form with the Submit button that sends the delete command to the server.
6. In the After Deleting, Go To 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.
7. 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.