Operation Manual

Building a delete record page
To the top
To the top
To the top
About record delete pages
Search for the record to delete
Create links to a delete page
Build the delete page
Add logic to delete the record
About record delete pages
Your application can contain a set of pages that lets users delete records in a database. The pages normally consist of a search page, a results
page, and a delete page. A delete page is usually a detail page working in tandem with a results page. The search and results pages let the user
retrieve the record and the delete page lets the user confirm and delete the record.
After creating the search and results pages, you add links on the results page to open the delete page and then build a delete page that displays
the records and a Submit button.
Search for the record to delete
When users want to delete a record, they must first find that record in the database. Accordingly, you need a search and a results page to work
with the delete page. The user enters search criteria in the search page and selects the record on the results page. When the user clicks the
record, the delete page opens and displays the record in an HTML form.
Create links to a delete page
After creating the search and results pages, you must create links on the results page to open the delete page. You then modify the links to pass
the IDs of the records the user wants to delete. The delete page uses this ID to find and display the record.
To create the links manually
1. 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.
2. Select the Columns option and the After Current Column option, and click OK.
A column is added to the table.
3. 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.
4. Select the Delete string to apply a link to it.
5. 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.
6. Select the Delete link on the results page.
7. (ColdFusion) In the Link box in the Property inspector, add the following string at the end of the URL:
?recordID=#recordsetName.fieldName#
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:
502