looks like Farcry is smart enough to work it out
<cfset qryDocs = application.fapi.getContentObjects(typename="dmFile",
lProperties="*", catFile_in="#stObj.CATDOCUMENT#,123,456") />
select *, 'dmFile' as typename
from dbo.dmFile
where 1=1
AND status in ('draft','pending','approved')
AND
objectid in (
select objectid
from dbo.refCategories
where categoryid in ('05867140-1C04-11E2-9C64005056830000','123','456')
)
On 22 October 2012 14:37, AJ Mercer <[email protected]> wrote:
> I would like to know how to use getContentObjects() to filter a given
> category when the type may have multiple.
>
> Currently, the type (dmFile) is set up like this
> <cfproperty ftSeq="30" ftFieldset="Categorisation" name="catFile"
> type="string" hint="Flag to make file shared." required="no"
> ftLabel="Category" ftType="category" ftalias="dmfile" />
>
> I am creating a rule which can select one category (may change
> to multiple later)
>
> How is getContentObjects() used to do this?
>
>
> --
>
> *AJ Mercer*
> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org
> community="Open" /> <http://webonix.org>
> http://twitter.com/webonix
> Railo Community Manager<http://www.getrailo.org/index.cfm/community/team/>
>
>
--
*AJ Mercer*
<webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org
community="Open" /> <http://webonix.org>
http://twitter.com/webonix
Railo Community Manager <http://www.getrailo.org/index.cfm/community/team/>
--
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
