Adobe Dreamweaver CC 2014 v.13 User Manual

Page 571

9. Click OK, and save your work.

To add a server behavior to delete the record (ASP)

1. Make sure the ASP delete page is open in Dreamweaver.

2. In the Server Behaviors panel (Window > Server Behaviors), click the Plus (+) button, and select Delete Record.

3. In the Connection pop-up menu, select a connection to the database so that the server behavior can connect to the affected database.

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

4. In the Delete from Table pop-up menu, select the database table that contains the records to be deleted.

5. In the Select Record From pop-up menu, specify the recordset that contains the records to be deleted.

6. 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.

7. In the Delete By Submitting pop-up menu, specify the HTML form with the Submit button that sends the delete command to the server.

8. In the After Deleting, Go To box, specify a page to open after the record has been deleted from the database table.

You can specify a page that contains a brief success message to the user, or a page listing the remaining records so that the user can verify
that the record has been deleted.

9. Click OK, and save your work.

Test your delete pages

1. Upload the search, results, and delete pages to your web server, open a browser and search for a disposable test record to delete.

When you click a Delete link on the results page, the delete page should appear.

2. Click the Confirm button to delete the record from the database.

3. Verify that the record has been deleted by searching for the record again. The record should no longer appear in the results page.