home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 139 / dpcs0999.iso / Web / CFserver / data1.cab / Examples / employee / _footer.cfm next >
Encoding:
Text File  |  1999-04-12  |  1.5 KB  |  42 lines
  1. <!--- The footer will contain a link to all the departments. --->
  2.  
  3. <!--- First we do a query to fetch the departments. --->
  4. <CFQUERY NAME="GetFooterLinks" DATASOURCE="CFExamples">
  5. SELECT DepartmentName, DepartmentID
  6. FROM EmpDepartments
  7. </CFQUERY>
  8.  
  9. <!--- Then we set up some formatting... --->
  10. <TR>
  11.     <TD COLSPAN="3">
  12.  
  13.         <TABLE BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="CENTER" BGCOLOR="#000066" WIDTH=620>
  14.         <TR>
  15.             <TD HEIGHT="25" COLSPAN="4" ALIGN="CENTER" BGCOLOR="#999999">
  16.                 <FONT FACE="Myriad Web, Verdana, Helvetica" SIZE="-1" COLOR="#333333">
  17.  
  18.                 <!--- Now we CFOUTPUT over the query we just executed. --->
  19.                 <CFOUTPUT QUERY="GetFooterLinks">
  20.                     <!--- Notice we're passing the DepartmentID in the URL... --->
  21.                     <A HREF="department.cfm?DepartmentID=#DepartmentID#">#DepartmentName#</A>
  22.                     <!--- The following line inserts a | if the current record does Not EQual the last record. --->
  23.                     <CFIF CurrentRow NEQ RecordCount>|</CFIF>
  24.                 </CFOUTPUT>
  25.                 </FONT>
  26.             </TD>
  27.         </TR>
  28.  
  29.         <TR>
  30.             <TD HEIGHT="25" COLSPAN="4" ALIGN="CENTER" BGCOLOR="666666">
  31.                 <FONT FACE="Myriad Web, Verdana, Helvetica" SIZE="-1" COLOR="#333333">
  32.                     <A HREF="insertform.cfm">Add New Employee</A> | 
  33.                     <A HREF="list.cfm">Complete Employee Listing</A> | 
  34.                     <A HREF="searchform.cfm">Directory Search</A> 
  35.                 </FONT>
  36.             </TD>
  37.         </TR>
  38.         </TABLE>
  39.  
  40.     </TD>
  41. </TR>
  42. </TABLE>