home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 139 / dpcs0999.iso / Web / CFserver / data1.cab / Examples / employee / ModifyAction.cfm < prev    next >
Encoding:
Text File  |  1999-04-12  |  647 b   |  19 lines
  1. <!--- This template takes info passed from ModifyForm.cfm and updates the database. --->
  2.  
  3. <CFQUERY DATASOURCE="CFexamples" NAME="ModifyEmployee">
  4. UPDATE EmpEmployees
  5. SET FirstName = '#Form.FirstName#',
  6.     LastName = '#Form.LastName#',
  7.     Title = '#Form.Title#',
  8.     DepartmentID = #Val(Form.DepartmentID)#,
  9.     Temporary = <CFIF IsDefined("Form.Temporary")>TRUE,<CFELSE>FALSE,</CFIF>
  10.     Email = '#Form.Email#',
  11.     Phone = '#Form.Phone#',
  12.     <CFIF Form.StartDate NEQ "">
  13.         StartDate = #CreateODBCDate(Form.StartDate)#,
  14.     </CFIF>
  15.     Personal = '#Form.Personal#'
  16. WHERE EmpID = #Val(Form.EmpID)#
  17. </CFQUERY>
  18.  
  19. <CFLOCATION URL="Details.cfm?EmpID=#EmpID#">