|
My clients have discovered that if a
page is requested for approval, and then sent back to draft, it does not show
up for the content persons ‘myFarCry’ home page. I think I have tracked it down to farcry_core\packages\farcry\_workflow\getUserDraftObjects.cfm
<cfset sql = "SELECT objectID, title, versionID, datetimelastUpdated
FROM #application.dbowner##i# WHERE status = 'draft' AND rtrim(versionID) = ''
AND (createdby = '#arguments.userLogin#' OR lastupdatedby =
'#arguments.userLogin#') ORDER BY datetimelastUpdated DESC"> I think the problem is that versionID is
not blank when testing for lastupdatedby. I would also be inclined to put parentheses
are the things that are been ORed. Regards, W: www.power.net.au
CAUTION
- This
message may contain privileged and confidential information intended only for
the use of the addressee named above. If you are not the intended recipient of
this message you are hereby notified that any use, dissemination, distribution
or reproduction of this message is prohibited. If you have received this
message in error please notify Power Business Systems immediately. Any views
expressed in this message are those of the individual sender and may not
necessarily reflect the views of Power Business Systems. You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 |
<<image001.jpg>>
