MACROMEDIA COLDFUSION 5-DEVELOPING, Руководство по разработке

Страница: 133 / 438

Deleting Data 113
8 View deleteform.cfm a browser by specifying the page URL and an Employee ID,
for example, http://localhost/myapps/updateform.cfm?Emp_ID=3. and click the
Submit button.
The employee is deleted from the Employee table and the message displays.
Reviewing the code
The following table describes the code and its function:
Deleting multiple records
You can use a SQL condition to delete several records. The following example deletes
the records for everyone in the Sales department (which has Dept_ID number 4)
from the Employee table:
DELETE FROM Employee
WHERE Dept_ID = 4
To delete all the records from the Employee table, you use the following code:
DELETE FROM Employee
Note
Deleting records from a database is not reversible. Use DELETE statements carefully.
Code Description
<cfquery name="DeleteEmployee"
datasource="CompanyInfo">
DELETE FROM Employee
WHERE Emp_ID = #Form.Emp_ID#
</cfquery>
Delete the record in the database whose
Emp_ID column matches the Emp_ID
(hidden) field on the form. Since the
Emp_ID is the table’s primary key, only one
record gets deleted.
<cfoutput>
You have deleted #Form.FirstName#
#Form.LastName# from the
Employees database.
</cfoutput>
Inform the user that the record was deleted.