User Guide

78 Chapter 5 Graphing Data

ORDER BY Employee.LastName, Employee.Firstname

</cfquery>

<html>

<head>

<title>Employee Salary Details</title>

</head>

<body>

<h1><cfoutput>#GetSalaryDetails.Dept_Name[1]# Department

Salary Details</cfoutput></h1>

<tr>

<th>Employee Name</td>

<th>StartDate</td>

<th>Salary</td>

<th>Contract?</td>

</tr>

<tr>

<td>#FirstName# #LastName#</td>

<td>#dateFormat(StartDate, "mm/dd/yyyy")#</td>

<td>#numberFormat(Salary, "$999,999")#</td>

<td>#Contract#</td>

</tr>

</cfoutput>

</table>

</body>

</html>

3 Save the page as Salary_details.cfm in myapps under the Web root directory.