Advertisement
Guest User

Untitled

a guest
Sep 28th, 2016
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. update tblTask
  2.             set
  3.                 statusID=#form.statusID#
  4.                 ,waitingUserID=<cfif form.statusID eq 5>#form.waitingUserID#<cfelse>null</cfif>
  5.                 ,percentComplete=#form.percentComplete#
  6.                 ,notes='#getTask.notes#<hr>#form.notes#'
  7.                 ,actualHours=#(getTask.estHours+form.actualHours)#
  8.                 ,dateComplete=null
  9.                 <cfif (listFind("5,6,7",getTask.statusID) and form.statusID eq 1) and (isDefined("form.dateDue") and dateDiff("d",form.dateDue,dateFormat(now())) lt 1)>
  10.                     ,dateDue=getdate()
  11.                 </cfif>
  12.             where
  13.                 taskID=#form.TaskID#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement