Basic HTML version of Foils prepared May 3 1998
| Deleting data in a database can be done with a single delete page. The delete page contains a CFQUERY tag with a SQL delete statement. |
| SQL delete statement is: |
| DELETE FROM tablename WHERE condition |
| <!-- Page to delete single employee record --> |
| <CFQUERY NAME="DeleteEmployee" |
| DATASOURCE="CF 3.0 Examples"> |
| DELETE FROM Employees |
| WHERE Employee_ID = #URL.EmployeeID# |
| </CFQUERY> |
| <HTML> |
| <HEAD><TITLE>Delete Employee Record</TITLE></HEAD> |
| <H3>The employee record has been deleted.</H3> |
| </HTML> |