Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update tblTask
- set
- statusID=#form.statusID#
- ,waitingUserID=<cfif form.statusID eq 5>#form.waitingUserID#<cfelse>null</cfif>
- ,percentComplete=#form.percentComplete#
- ,notes='#getTask.notes#<hr>#form.notes#'
- ,actualHours=#(getTask.estHours+form.actualHours)#
- ,dateComplete=null
- <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)>
- ,dateDue=getdate()
- </cfif>
- where
- taskID=#form.TaskID#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement