Building record delete pages in Dreamweaver

On the results page, create a column in the table used to display records by clicking inside the last table column and selecting Modify > Table > Insert Rows or Columns.

Select the Columns option and the After Current Column option, and click OK.

A column is added to the table.

In the newly created table column, enter the string Delete in the row containing the dynamic content placeholders. Make sure you enter the string inside the tabbed repeating region.

You can also insert an image with a word or symbol for delete.

Select the Delete string to apply a link to it.

In the Property inspector, enter the delete page in the Link box. You can enter any filename.

After clicking outside the Link box, the Delete string appears linked in the table. If you Live view, you can see that the link is applied to the same text in every table row.

Select the Delete link on the results page.

(ColdFusion) In the Link box in the Property inspector, add the following string at the end of the URL:

The question mark tells the server that what follows is one or more URL parameters. The word recordID is the name of the URL parameter (you can make up any name you like). Note the name of the URL parameter because you'll use it in the delete page later.

The expression after the equal sign is the value of the parameter. In this case, the value is generated by a ColdFusion expression that returns a record ID from the recordset. A different ID is generated for each row in the dynamic table. In the ColdFusion expression, replace recordsetName with the name of your recordset, and replace fieldName with the name of the field in your recordset that uniquely identifies each record. In most cases, the field will consist of a record ID number. In the following example, the field consists of unique location codes:

When the page runs, the values of the recordset's CODE field are inserted in the corresponding rows in the dynamic table. For example, if the Canberra, Australia, rental location has the code CBR, the following URL is used in the Canberra row in the dynamic table:

(PHP) In the Link field in the Property inspector, add the following string at the end of the URL:

The question mark tells the server that what follows is one or more URL parameters. The word recordID is the name of the URL parameter (you can make up any name you like). Note the name of the URL parameter because you'll use it in the delete page later.

The expression after the equal sign is the value of the parameter. In this case, the value is generated by a PHP expression that returns a record ID from the recordset. A different ID is generated for each row in the dynamic table. In the PHP expression, replace recordsetName with the name of your recordset, and replace fieldName with the name of the field in your recordset that uniquely identifies each record. In most cases, the field will consist of a record ID number. In the following example, the field consists of unique location codes:

When the page runs, the values of the recordset's CODE field are inserted in the corresponding rows in the dynamic table. For example, if the Canberra, Australia, rental location has the code CBR, the following URL is used in the Canberra row in the dynamic table:

(ASP) In the Link field in the Property inspector, add the following string at the end of the URL:

The question mark tells the server that what follows is one or more URL parameters. The word recordID is the name of the URL parameter (you can make up any name you like). Note the name of the URL parameter because you'll use it in the delete page later.

The expression after the equal sign is the value of the parameter. In this case, the value is generated by an ASP expression that returns a record ID from the recordset. A different ID is generated for each row in the dynamic table. In the ASP expression, replace recordsetName with the name of your recordset, and replace fieldName with the name of the field in your recordset that uniquely identifies each record. In most cases, the field will consist of a record ID number. In the following example, the field consists of unique location codes:

When the page runs, the values of the recordset's CODE field are inserted in the corresponding rows in the dynamic table. For example, if the Canberra, Australia, rental location has the code CBR, the following URL is used in the Canberra row in the dynamic table:

Save the page.

On the results page, create a column in the table used to display records by clicking inside the last table column and selecting Modify > Table > Insert Rows or Columns.

Select the Columns option and the After Current Column option, and click OK.

A column is added to the table.

In the newly created table column, enter the string Delete in the row containing the dynamic content placeholders. Make sure you enter the string inside the tabbed repeating region.

You can also insert an image with a word or symbol for delete.

Select the Delete string to apply a link to it.

In the Server Behaviors panel (Window > Server Behaviors), click the Plus (+) button, and select Go to Detail Page from the pop‑up menu.

In the Detail Page box, click Browse and locate the delete page.

In the Pass URL Parameter box, specify the name of your parameter, such as recordID.

You can make up any name you like, but take note of the name because you'll use it in the delete page later.

Specify the value you want to pass to the delete page by selecting a recordset and a column from the Recordset and Column pop‑up menus. Typically the value is unique to the record, such as the record’s unique key ID.

Select the URL Parameters option.

Click OK.

A special link surrounds the selected text. When the user clicks the link, the Go To Detail Page server behavior passes a URL parameter containing the record ID to the specified delete page. For example, if the URL parameter is called recordID and the delete page is called confirmdelete.asp, the URL looks something like the following when the user clicks on the link:

http://www.mysite.com/confirmdelete.asp?recordID=43

The first part of the URL, http://www.mysite.com/confirmdelete.asp, opens the delete page. The second part, ?recordID=43, is the URL parameter. It tells the delete page what record to find and display. The term recordID is the name of the URL parameter and 43 is its value. In this example, the URL parameter contains the record’s ID number, 43.

Create a page and save it as the delete page you specified in the previous section.

You specified a delete page when you created the Delete link in the previous section. Use this name when saving the file for the first time (for example, deleteConfirm.cfm).

Insert an HTML form on the page (Insert > Form > Form).

Add a hidden form field to the form.

The hidden form field is required to store the record ID passed by the URL parameter. To add a hidden field, place the insertion point in the form and select Insert > Form > Hidden Field.

Add a button to the form.

The user will click the button to confirm and delete the displayed record. To add a button, place the insertion point in the form and select Insert > Form > Button.

Enhance the design of the page any way you want and save it.

In the Bindings panel (Window > Bindings), click the Plus (+) button and select Recordset (Query) from the pop‑up menu.

The simple Recordset or DataSet dialog box appears. If the advanced Recordset dialog box appears instead, click Simple.

Name the recordset, and select a data source and the database table that contains the records that users can delete.

In the Columns area, select the table columns (record fields) you want to display on the page.

To display only some of the record’s fields, click Selected and choose the desired fields by Control‑clicking (Windows) or Command-clicking (Macintosh) them in the list.

Make sure to include the record ID field even if you won't be displaying it.

Complete the Filter section as follows to find and display the record specified in the URL parameter passed by the results page:

• From the first pop‑up menu in the Filter area, select the column in the recordset containing values that match the value of the URL parameter passed by the page with the Delete links. For example, if the URL parameter contains a record ID number, select the column containing record ID numbers. In the example discussed in the previous section, the recordset column called CODE contains the values that match the value of the URL parameter passed by the page with the Delete links.

• From the pop‑up menu beside the first menu, select the equal sign, if not already selected.

• From the third pop‑up menu, select URL Parameter. The page with the Delete links uses a URL parameter to pass information to the delete page.

• In the fourth box, enter the name of the URL parameter passed by the page with the Delete links.

   

Click OK.

The recordset appears in the Bindings panel.

Select the recordset columns (record fields) in the Bindings panel, and drag them to the delete page.

Make sure you insert this read-only dynamic content within the form boundaries. For more information on inserting dynamic content in a page, see Make text dynamic.

Next, you must bind the record ID column to the hidden form field.

Make sure Invisible Elements are enabled (View > Visual Aids > Invisible Elements), and then click the yellow shield icon that represents the hidden form field.

The hidden form field is selected.

In the Property inspector, click the lightning bolt icon beside the Value box.

In the Dynamic Data dialog box, select the record ID column in the recordset.

In the following example, the record ID column, CODE, contains unique store codes.

Click OK and save the page.

Make sure the ColdFusion or PHP delete page is open in Dreamweaver.

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

In the First Check If Variable Is Defined box, make sure Primary Key Value is selected.

You specify the primary key value later in the dialog box.

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.

In the Table pop‑up menu, select the database table that contains the records that will be deleted.

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.

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

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.

Click OK, and save your work.

Make sure the ASP delete page is open in Dreamweaver.

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

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.

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

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

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.

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

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.

Click OK, and save your work.

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.

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

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