|
Attached is what I believe to be a
resolution to the versioning problem. From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Mercer Maybe this should be the SQL SELECT objectID, title, versionID,
datetimelastUpdated FROM dmHTML WHERE status = 'draft' AND (rtrim(versionID) = '' AND createdby
= 'fred') OR (rtrim(versionID) != '' and
lastupdatedby = 'fred') ORDER BY datetimelastUpdated DESC But I think this will only work when
there is another version of the object..? From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Mercer 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. --- --- |
<<image001.jpg>>
getUserDraftObjects.cfm
Description: getUserDraftObjects.cfm
--- 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
