View and Add Employees

ColdFusion Code - "employee.cfm"

<cfif (IsDefined('Form.Action') AND Form.Action EQ "Insert")>
	<cflock name="Insert" type="EXCLUSIVE" timeout="30">
			<cfquery name="insertemployee" Datasource="employee">
				INSERT INTO Employee (FirstName, LastName, JobTitle, Phone, Fax)
				VALUES ('#Form.FirstName#', '#Form.LastName#', '#Form.JobTitle#', '#Form.Phone#', '#Form.Fax#')
			</cfquery>
	</cflock>
<cfelseif (IsDefined('Form.Action') AND Form.Action EQ "Delete")>
	<cflock name="Delete" type="EXCLUSIVE" timeout="30">
			<cfquery name="deleteemployee" Datasource="employee">
				DELETE FROM Employee
				WHERE EmpID = #Form.EmpID#
			</cfquery>
	</cflock>
</cfif>
<cfquery name="listemployees" datasource="employee">
	SELECT *
	FROM Employee
	ORDER BY LastName
</cfquery>
<table cellpadding="4">
<thead>
	<tr>
		<td width="50"> </td>
		<td><b>Last Name</b></td>
		<td><b>First Name</b></td>
		<td><b>Job Title</b></td>
		<td><b>Phone</b></td>
		<td><b>Fax</b></td>
	</tr>
</thead>
<tbody>
<cfoutput query="listemployees">
	<tr id="#EmpID#" onmouseover="hiliteRow('#EmpID#','hilite');show('remove_#EmpID#');" onmouseout="hiliteRow('#EmpID#','white');hide('remove_#EmpID#');">
		<td width="50"><span id="remove_#EmpID#" class="hidden"><a href="javascript://" onclick="deleteEmployee('#EmpID#');">delete</a></span></td>
		<td>#LastName#</td>
		<td>#FirstName#</td>
		<td>#JobTitle#</td>
		<td>#Phone#</td>
		<td>#Fax#</td>
	</tr>
</cfoutput>
</tbody>
</table>

UPDATE: The following will not work on this server as this is coldfusion code and the server this file is on no longer supports coldfusion. However, the code hasn't changed, and will work on a coldfusion server.