Ok I have figured out how to get a list of dmhtml object ID's to NOT
be included in the results, but I need some help on..
1. optimizing this?
2. at the end, how do I QofQ to "remove" the ids?
I'm not good at this type of SQL... I need a Where NOT IN (list). type
select.
You smarties probably know a better way to filter out the objectIDs
now that I have a list. teh objecID is the "key" in qresults.
<!--- determine the policy groups (or roles) this user belongs to --->
<cfif isDefined("session.dmsec.authentication.lPolicyGroupIDs") and
listLen(session.dmsec.authentication.lPolicyGroupIDs)>
<!--- concatenate logged in group permissions with anonymous group
permissions --->
<cfset lpolicyGroupIds = session.dmsec.authentication.lPolicyGroupIDs
& "," & application.dmsec.ldefaultpolicygroups>
<cfelse>
<!--- user not logged in, assume anonymous permissions --->
<cfset lpolicyGroupIds = application.dmsec.ldefaultpolicygroups>
</cfif>
<cfset lHideDMHTMLs = "">
<cfloop query="qResults">
<cfif custom1 EQ "dmhtml">
<cfset objNavigation =
CreateObject("component","#Application.packagepath#.types.dmNavigation")>
<cfset qNavigation = objNavigation.getParent(key)>
<cfset ViewOK =
request.dmSec.oAuthorisation.checkPermission(permissionName="View",objectID=qNavigation.parentid,lPolicyGroupIDs=lpolicyGroupIds)>
<cfif ViewOK NEQ 1>
<cfset lHideDMHTMLs =
ListAppend(lHideDMHTMLs,qNavigation.parentid)>
</cfif>
</cfif>
</cfloop>
<cfquery name="qFilteredResults" dbtype="query">
SELECT * FROM qResults
WHERE 0=0
AND .................................
</cfquery>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
