maybe take a look at cfindex custom[1..4] I think Farcry uses the first 3, but 4 is free. You can store your own value in here then use that for your filtering.
It is just a text field, so if you have multiple things you want to store, you can use a list. 2009/6/25 Chris Roth <[email protected]> > > 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> > > > -- AJ Mercer Web Log: http://webonix.net --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
