home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 139 / dpcs0999.iso / Web / CFserver / data1.cab / Examples / employee / Development.cfm < prev    next >
Encoding:
Text File  |  1999-04-12  |  1.5 KB  |  58 lines
  1. <!--- This template lists the employees, grouped by department, and lets
  2.     the user click on an employee to view details --->
  3.  
  4. <!--- These two lines set up the <HEAD></HEAD>,
  5.     title, and nav bar --->
  6. <CFSET Title="Development">
  7. <CFINCLUDE TEMPLATE="_header.cfm">
  8.  
  9. <!--- Get employees (and their departments); and order by
  10.     department because that's what we're going to group by --->
  11. <CFQUERY DATASOURCE="CFexamples" NAME="GetEmployees">
  12. SELECT * FROM EmpEmployees
  13. WHERE EmpEmployees.DepartmentID = 1
  14. ORDER BY EmpEmployees.DepartmentID, LastName, FirstName
  15. </CFQUERY>
  16.  
  17. <CFOUTPUT QUERY="GetEmployees" GROUP="DepartmentID">
  18. <table width="100%" border="0" cellspacing="0" cellpadding="0">
  19.  
  20. <!--- Now we start outputting for every record
  21.         (i.e. every employee) --->
  22.     <CFOUTPUT>
  23.     <TR>
  24.         <td align="RIGHT" valign="TOP">
  25.         <cfif #picture# neq "" >
  26.             <img src="#picture#" height="200" hspace=25 border=0 alt="">
  27.         </cfif>
  28.         </td>
  29.         <td valign="top" width="100%">
  30.         <font face="Myriad Web, Verdana, Helvetica" size="+2">
  31.             <A HREF="Details.cfm?EmpID=#EmpID#">#FirstName# #LastName#</A><br>
  32.         </font>
  33.         <FONT FACE="Arial, Geneva, Helvetica" SIZE="-2">
  34.             #Title#<BR>
  35.             <br>
  36.         </font>
  37.         <FONT FACE="Arial, Geneva, Helvetica" SIZE="-1">
  38.         <p>
  39.             #personal#
  40.         </p>
  41.         <p>
  42.             #Phone#<BR>
  43.             <A HREF="mailto:#Email#">#Email#</A><BR>
  44.         </p>
  45.         </font>
  46.         </TD>
  47.         <td width="100" nowrap> </td>
  48.     </TR>
  49.     <tr><td height=35> </td></tr>
  50.     </CFOUTPUT>
  51.  
  52. </CFOUTPUT>
  53.  
  54. </TABLE>
  55. <cfinclude template="_footer.cfm">
  56. </BODY>
  57. </HTML>
  58.