[farcry-dev] getBloodLine returning empty queries

[Tim Lucas]

After many tiresome hours fighting sleep and a runny nose i've come so 
close but this bugger of a thing is returning an empty query:

qGetBloodLine = 
request.factory.oTree.getBloodLine(jointable="dmhtml",objectid="#request.navid#",levelsabove="2");

is there something i'm missing here?

I've debugged the SQL:

select distinct nto.*, j.* from nested_tree_objects nto inner join 
dmhtml j on nto.objectid = j.objectid where 1 = 1 and ( nto.parentid in 
('4EA446C9-20ED-4AF5-9B044F0F097EF571','4EA446B9-20ED-4AF5-9BC6EFD8F0A046FB') 
or nto.objectid in 
('4EA446C9-20ED-4AF5-9B044F0F097EF571','4EA446B9-20ED-4AF5-9BC6EFD8F0A046FB') 
) order by nto.nleft;

and it returns an empty result set.

Without giving you a dump of the tree and what it actually should return 
(because i just can't be buggered at the moment) can anybodys eyes see 
anything wrong with the call to getBloodLine that mine can't?

I tried it on another farcry app and it also returns an empty query.

Thanks
-- tim
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004