Try this
Farcry 3 tree caching - Admin -> General -> CategoryCacheTimeSpan - set it to 0.
On 3/31/06, Gavin Cooney <[EMAIL PROTECTED]> wrote:
i turned debugging on and got this:
qReturn (Datasource=farcry_arc, Time=0ms, Records=17, Cached Query) in
/path-to-farcry/farcry_core/packages/farcry/tree.cfc @ 14:10:55.055
SELECT ntm.objectid,ntm.parentid,ntm.typename,ntm.nleft,ntm.nright,ntm.nlevel,ntm.ObjectName
FROM nested_tree_objects ntm
INNER JOIN dmNavigation t ON t.objectid = ntm.objectid
AND ntm.nleft>945
AND ntm.nleft <2016
AND ntm.typename = 'dmNavigation'
AND ntm.nlevel <= 3
AND status IN ('approved')
ORDER BY ntm.nleft
When i copy and paste this into my mysql client, i get 5 records, not 17...
oh damn it... it's a cached query...
why is it caching queries!?
thanks
Gav
On 3/31/06, Andrew Mercer < [EMAIL PROTECTED]> wrote:
>
> just an idea.
>
> have you got debugging on?
> maybe see if you can find the sql farcry has generated and run that on the
> database yourself.
>
>
>
> On 3/31/06, Gavin Cooney <[EMAIL PROTECTED]> wrote:
> >
> > hey,
> >
> >
> http://www.farcrycms.org/cfcdoc/content.cfm?file=c%3A%2Ffarcry%2Fp230%2Ffarcry%5Fcore%2Fpackages%5Cfarcry%5Ctree%2Ecfc#getDescendants()
> >
> > yes, it seems to.
> >
> > and it seems like it's implemented too... judging by the code here.
> >
> > or am i looking at the wrong getdescendants?
> >
> > Gav
> >
> >
> > On 3/31/06, Andrew Mercer <[EMAIL PROTECTED]> wrote:
> > >
> > > I dont have farcry in front of me at the moment,
> > > but does getDescendants() have a afilter argument?
> > >
> > >
> > >
> > >
> > > On 3/31/06, Gavin Cooney < [EMAIL PROTECTED]> wrote:
> > > >
> > > > hi guys
> > > >
> > > > I'm running this code
> > > >
> > > > <cfscript>
> > > > navFilter=arrayNew(1);
> > > > navfilter[1]="status IN (#listQualify(
> request.mode.lvalidstatus ,
> > > "'")#)";
> > > > qGetChildren =
> > > application.factory.oTree.getDescendants(
> > > > objectid=request.navid,
> depth=1,
> > > afilter=navFilter);
> > > > </cfscript>
> > > >
> > > > I've dumped navFilter and it's:
> > > > navFilter[1] = status IN ('approved')
> > > >
> > > > and it is returning draft nav nodes.
> > > >
> > > > I'm using FC 3 and am supposed to be launching the site in the next
> > > > few hours... any ideas before i headbut my monitor?
> > > >
> > > > Gav
> > > >
> > > > --
> > > > www.gavcooney.com
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > >
> > >
> >
> >
> > --
> > www.gavcooney.com
> >
> >
> >
> >
>
>
> >
>
--
www.gavcooney.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
