home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 139 / dpcs0999.iso / Web / CFserver / data1.cab / Examples / employee / SearchAction.cfm < prev    next >
Encoding:
Text File  |  1999-04-12  |  1.6 KB  |  58 lines
  1. <CFINCLUDE TEMPLATE="_header.cfm">
  2.  
  3. <CFQUERY DATASOURCE="CFexamples" NAME="SearchResults">
  4.     SELECT * FROM EmpEmployees, EmpDepartments
  5.     WHERE EmpEmployees.DepartmentID = EmpDepartments.DepartmentID
  6.  
  7.     <CFIF Form.Name NEQ "">
  8.     AND (FirstName LIKE '%#Form.Name#%'
  9.         OR LastName LIKE '%#Form.Name#%'
  10.         OR FirstName & ' ' & LastName LIKE '%#Form.Name#%')
  11.     </CFIF>
  12.     
  13.     <CFIF Form.DepartmentID NEQ "All">
  14.     AND EmpEmployees.DepartmentID = #Val(Form.DepartmentID)#
  15.     </CFIF>
  16.  
  17.     ORDER BY DepartmentName, EmpEmployees.DepartmentID, LastName, FirstName
  18. </CFQUERY>
  19.  
  20. <TR>
  21.     <TD COLSPAN="3">
  22.         <FONT FACE="Arial, Geneva, Helvetica" SIZE="-1">
  23.             <P><CFOUTPUT>Your search for <B>"#Form.Name#"</B> has returned <B>#SearchResults.RecordCount#</B> employee(s).</CFOUTPUT></P>
  24.         </FONT>
  25.     </TD>
  26. </TR>
  27. <TR>
  28.     <TD HEIGHT="50" COLSPAN="3"> </TD>
  29. </TR>
  30.  
  31. <CFOUTPUT QUERY="SearchResults">
  32. <TR>
  33.  
  34.        <TD WIDTH=100 ALIGN="RIGHT" VALIGN="TOP" HEIGHT="150"> </TD>
  35.  
  36.     <TD VALIGN="top">
  37.         <FONT FACE="Myriad Web, Verdana, Helvetica" SIZE="+2">
  38.             <!--- Notice we're passing the EmpID in the URL... --->
  39.             <A HREF="Details.cfm?EmpID=#EmpID#">#FirstName# #LastName#</A><BR>
  40.         </FONT>
  41.     
  42.         <FONT FACE="Helvetica">
  43.             <FONT SIZE="-2">#Title#<BR><BR></FONT>
  44.             <FONT SIZE="-1">
  45.                 <CFIF Phone NEQ ""><FONT FACE="WingDings">(</FONT> #Phone#<BR></CFIF>
  46.                 <CFIF Email NEQ ""><FONT FACE="WingDings">*</FONT> <A HREF="mailto:#Email#">#Email#</A><BR></CFIF></P>
  47.             </FONT>
  48.         </FONT>
  49.     </TD>
  50.     
  51.     <TD WIDTH="100" NOWRAP> </TD>
  52.  
  53. </TR>
  54. </CFOUTPUT>
  55.  
  56. </TABLE>
  57.  
  58. <CFINCLUDE TEMPLATE="_footer.cfm">