Manualshelf

Operation Manual

ManualsBrandsAdobe ManualsSoftwareDreamweaver CC - 2015
681682683684685686687688689690
Table Of Contents
678
Building applications visually
Last updated 11/30/2015
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.
8 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.
9 Click OK, and save your work.
Test your delete pages
1 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.
2 Click the Confirm button to delete the record from the database.
3 Verify that the record has been deleted by searching for the record again. The record should no longer appear in the
results page.
More Help topics
Building search and results pages
URL parameters
Building pages with advanced data manipulation
objects (ColdFusion, ASP)
Note: The user interface has been simplified in Dreamweaver CC and later. As a result, you may not find some of the
options described in this article in Dreamweaver CC and later. For more information, see
this article.
About ASP command objects
An ASP command object is a server object that performs some operation on a database. The object can contain any valid
SQL statement, including one that returns a recordset, or one that inserts, updates, or deletes records in a database. A
command object can alter the structure of a database if the SQL statement adds or deletes a column in a table. You can
also use a command object to run a stored procedure in a database.