home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 139 / dpcs0999.iso / Web / CFserver / data1.cab / Examples / employee / ModifyForm.cfm < prev    next >
Encoding:
Text File  |  1999-04-12  |  2.3 KB  |  84 lines
  1. <!--- This template is just an HTML form that passes information to ModifyAction.cfm.
  2.     Each of the input elements have default values from the database. --->
  3.  
  4. <CFINCLUDE TEMPLATE="_header.cfm">
  5.  
  6. <CFQUERY DATASOURCE="CFexamples" NAME="GetDepartments">
  7. SELECT * FROM EmpDepartments
  8. ORDER BY DepartmentName
  9. </CFQUERY>
  10.  
  11. <!--- The query GetEmployee will be used to populate the input fields. --->
  12. <CFQUERY DATASOURCE="CFexamples" NAME="GetEmployee">
  13. SELECT * FROM EmpEmployees, EmpDepartments
  14. WHERE EmpEmployees.DepartmentID = EmpDepartments.DepartmentID
  15.     AND EmpEmployees.EmpID = #Val(URL.EmpID)#
  16. </CFQUERY>
  17.  
  18. <TR>
  19.        <TD WIDTH=100 ALIGN="RIGHT" VALIGN="TOP" HEIGHT="150"> </TD>
  20.  
  21.     <TD VALIGN="TOP">
  22.  
  23.         <CFOUTPUT QUERY="GetEmployee">
  24.         
  25.         <CFFORM ACTION="ModifyAction.cfm" METHOD="POST">
  26.         <INPUT TYPE="HIDDEN" NAME="EmpID" VALUE="#EmpID#">
  27.         
  28.         <FONT FACE="Helvetica" SIZE="-1">
  29.  
  30.         <P>First Name<BR>
  31.         <CFINPUT TYPE="TEXT" NAME="FirstName" VALUE="#FirstName#" REQUIRED="YES" MESSAGE="You must enter a first name."></P>
  32.         
  33.         <P>Last Name<BR>
  34.         <CFINPUT TYPE="TEXT" NAME="LastName" VALUE="#LastName#" REQUIRED="YES" MESSAGE="You must enter a first name."></P>
  35.         
  36.         <P>Title<BR>
  37.         <INPUT TYPE="TEXT" NAME="Title" VALUE="#Title#"></P>
  38.         
  39.         <P>Department<BR>
  40.         <SELECT NAME="DepartmentID">
  41.             <CFLOOP QUERY="GetDepartments">
  42.                 <OPTION VALUE="#DepartmentID#"
  43.                 <CFIF DEPARTMENTID IS GETEMPLOYEE.DEPARTMENTID>SELECTED</CFIF>
  44.                 >
  45.                 #DepartmentName#
  46.             </CFLOOP>
  47.         </SELECT></P>
  48.         
  49.         <P><INPUT TYPE="CHECKBOX" NAME="Temporary"
  50.         <CFIF TEMPORARY IS TRUE>CHECKED</CFIF>
  51.         >Temporary</P>
  52.         
  53.         <P>E-mail<BR>
  54.         <INPUT TYPE="TEXT" NAME="Email" VALUE="#Email#"></P>
  55.         
  56.         <P>Phone<BR>
  57.         <INPUT TYPE="TEXT" NAME="Phone" VALUE="#Phone#"></P>
  58.         
  59.         <P>Start Date<BR>
  60.         <CFINPUT TYPE="TEXT" NAME="StartDate" VALIDATE="date" MESSAGE="Please enter a valid start date." VALUE="#DateFormat(StartDate,"mm/dd/yy")#"></P>
  61.         
  62.         <P>Personal Information<BR>
  63.         <TEXTAREA NAME="personal" COLS="25" ROWS="5">#personal#</TEXTAREA>
  64.         
  65.         <P><INPUT TYPE="SUBMIT" VALUE="Modify"></P>
  66.  
  67.         </FONT>
  68.         
  69.         </CFFORM>
  70.         </CFOUTPUT>
  71.  
  72.     </TD>
  73.  
  74.        <TD WIDTH=100 ALIGN="RIGHT" VALIGN="TOP" HEIGHT="150"> </TD>
  75.  
  76. </TR>
  77.  
  78. <TR>
  79.     <TD HEIGHT="35" COLSPAN="3"> </TD>
  80. </TR>
  81.  
  82. </TABLE>
  83.  
  84. <CFINCLUDE TEMPLATE="_footer.cfm">