forgot link

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_i_06.html


2009/6/25 AJ Mercer <[email protected]>

> 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
>



-- 
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to