in the Link field in Java

Drawer QR Code in Java in the Link field

After you create a delete link that opens the confirmation page (which you can read about in the preceding section), you want to modify that link so that it passes the identity of the record that the user wants to delete To define the URL parameter that identifies which record to delete, follow these steps:

1 Follow Steps 1 through 6 in the Creating delete links to open the confirmation page section, earlier in this chapter The deletion process follows a parallel pattern to the record update

deleted on the confirmation page For the employee table example, we am using the last name field In a real-world situation, you would probably want to add more fields to confirm the deletion But for this purpose, the last name field works fine Figure 4-11 shows the two parameters for the employee table

The Select File dialog box appears with an updated value in the URL field The value in this field varies depending on your dynamic page type

The results page is complete The delete link now appears on the page, as shown in Figure 4-12

The Confirmation page simply displays enough information to identify the record that s about to be deleted This page consists of a form with a confirmation button To create a page that confirms the record deletion, you need to send two parameters to the confirmation page: The record ID A field to display the name of that record This page saves you from having to create another recordset with a filter to look up information that s already been retrieved from the database

Follow these steps to create the confirmation page:

6 Choose Insert Form to add a form 7 Choose Insert Form Hidden Field to add a hidden field to store the

record ID The user doesn t need to see the empid, but that ID needs to be part of the form submission

bindings list For the example, we selected the empid URL parameter You can leave the other fields set to their defaults

In the Properties inspector, Dreamweaver updates the Value field with dynamic code to place the URL parameter into the hidden form field

Dynamic Text from the plus (+) menu of the Server Behaviors panel The Dynamic Text dialog box appears, as shown in Figure 4-13

16 17 18 19

Type delete_btn in the ID field Click OK to close the dialog box Select the button In the Properties inspector, enter Delete in the Value field The button s text changes to Delete, as shown in Figure 4-14

Use the name that you selected when creating the Delete link (see Creating delete links to open the confirmation page, earlier in this chapter) But wait, there s more! The page isn t complete yet because it can t actually process the deletion You need to add logic to delete the record, as described in the following section

Dreamweaver adds the logic to perform the database deletion with the Delete Record server behavior To add this behavior to the HTML form, follow these steps:

3 Select the appropriate database connection from the Connection dropdown list This field may appear differently depending on your dynamic page code type

4 Select the table that you want to delete from the Table drop-down list 5 Select the primary key column from the Primary Key Column dropdown list We left the Numeric check box checked in our example because the empid record is a numeric field

open after deleting the record We entered successphp for the example You can make this page as simple as the statement Deleted Successfully The Delete Record dialog box for the example looks like Figure 4-15