Adobe is changing the world through digital experiences. Our creative, marketing and document solutions empower everyone — from emerging artists to global brands — to bring digital creations to life and deliver them to the right person
at the right moment for the best results.
To retrieve and delete a record, you must first define a filtered recordset for the results/delete page.
To retrieve the record to delete:
1
Open the results/delete page in Dreamweaver UltraDev.
Note: This should be a "clean" page that contains no server behaviors.
2
In the Data Bindings panel (Window > Data Bindings), click the plus (+) button and choose Recordset (Query).
If the advanced Recordset dialog box appears, click the Simple button to open the simple Recordset dialog box.
3
Name the recordset and specify where the data you want to delete is located using the Connection and Table pop-up menus.
4
In the Columns area, select the All option to select all the columns in the database table.
5
Configure the Filter area so that the values of a table column are checked against the value of the search page's corresponding URL parameter.
Choose a table column from the Filter pop-up menu. If your search page asks for an employee's last name, choose the appropriate column (in this case LASTNAME). This ensures that the results/delete page will include only those values that match the search parameter.
From the pop-up menu beside the first menu, choose the equal (=) sign. (It should be the default.)
From the third pop-up menu, choose URL Parameter. (It should be the default.)
In the last text box, enter the name of the form object used to collect the search parameter on the search page. If your search form uses a text field to conduct the search, this is the name of the text field.
You can get the name of the search text field by switching back to your search page and viewing the text field's Property inspector (Window > Properties).
The "txtLastName" text field passes a specific URL parameter on to the results page.
The following image shows the completed results/delete page filter area:
6
Click OK.
The results/delete page now contains a filtered recordset. The page will generate a result that corresponds to the information submitted by the search page.
