home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 139 / dpcs0999.iso / Web / CFserver / data1.cab / Examples / employee / SearchForm.cfm < prev    next >
Encoding:
Text File  |  1999-04-12  |  809 b   |  33 lines
  1. <CFSET TITLE = "Employee Search">
  2. <CFINCLUDE TEMPLATE="_header.cfm">
  3.  
  4. <CFQUERY DATASOURCE="CFexamples" NAME="GetDepartments">
  5. SELECT * FROM EmpDepartments
  6. </CFQUERY>
  7. <TR>
  8.     <TD HEIGHT="250" WIDTH="10" nowrap> </TD>
  9.     <TD VALIGN="TOP">
  10.         <FORM ACTION="SearchAction.cfm" METHOD="POST">
  11.         <FONT FACE="Myriad Web, Verdana, Helvetica" SIZE="-1">
  12.  
  13.         <P>Name (first, last, or both)<BR>
  14.         <INPUT TYPE="TEXT" NAME="Name"></P>
  15.  
  16.         <P>Department<BR>
  17.         <SELECT NAME="DepartmentID">
  18.             <OPTION VALUE="All">Search All
  19.             <CFOUTPUT QUERY="GetDepartments">
  20.                 <OPTION VALUE="#DepartmentID#">#DepartmentName#
  21.             </CFOUTPUT>
  22.         </SELECT></P>
  23.  
  24.         <P><INPUT TYPE="SUBMIT" VALUE="Search"></P>
  25.  
  26.  
  27.         </FONT>
  28.         </FORM>
  29.     </TD>
  30.     <TD> </TD>
  31. </TR>
  32. </TABLE>
  33. <CFINCLUDE TEMPLATE="_footer.cfm">