Hoping someone on this list might be doing this already, as I seem to
be chaing my tail.
I am trying to figure out the best place to filter the collections
search (as well as displayed in the search form) based on Role.
Right now I am looking at getCollections() in verityConfig.cfc
<cffunction name="getCollections" access="private" output="false"
returntype="query">
<cfset var qCollections=queryNew("configid, title,
collectionname")>
<cfquery datasource="#application.dsn#" name="qCollections">
SELECT objectid AS configid, title, collectionname
FROM farVerityCollection
WHERE bEnableSearch = 1
AND hostname = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#variables.hostname#" />
AND collectionname LIKE <cfqueryparam cfsqltype="cf_sql_varchar"
value="#application.ApplicationName#/_%" /> escape '/'
ORDER BY title
</cfquery>
<cfreturn qCollections />
</cffunction>
--~--~---------~--~----~------------~-------~--~----~
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
-~----------~----~----~----~------~----~------~--~---
