Adobe Dreamweaver CC 2015 - Manual (Page 668)

661
Building applications visually
Last updated 6/3/2015
4 In the Connection or Data Source (ColdFusion) pop-up menu, select a connection to the database so that the server
behavior can connect to the affected database.
5 In the Table pop-up menu, select the database table that contains the records that will be deleted.
6 In the Primary Key Column pop-up menu, select the table column that contains record IDs.
The Delete Record server behavior searches this column for a match. The column should contain the same record
ID data as the recordset column you bound to the hidden form field on the page.
If the record ID is numeric, select the Numeric option.
7 (PHP) In the Primary Key Value pop-up menu, select the variable on your page that contains the record ID
identifying the record to be deleted.
The variable is created by your hidden form field. It has the same name as the name attribute of the hidden field and
is either a form or URL parameter, depending on the form’s method attribute.
8 In the After Deleting, Go To box, or the On Success, 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.
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.