Wow. Does that really perform OK on large recordsets? If I'm getting it right, if you had 100,000 records and wanted all of the top level set members (the problem would be smalle for lower level nodes), you'd run a query which would find every record, compute the sub query for each record as part of the filter and then only return the records with the appropriate sub query value. Does that scale well to large record sets?
Best Wishes, Peter -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 6:30 PM To: CF-Talk Subject: Re: SPAM-LOW: Re: Nested Set Model > however if the children also have children, how do i just pull out the > first generation of children? You do a query that selects all decendants of the parent node in question, except those that have have more than zero intervening ancestors. To put that another way, you do a query for all decendants of the node and compute their depth, and only return nodes that have a depth of 1. cheers, barneyb On 2/1/06, Mike Little <[EMAIL PROTECTED]> wrote: > guys, on many sites i have looked at - when you click a category the > link includes an x=&y= in the querystring. would this be referring to > the left and right columns of a nested model i wonder?? > > so if i know the left and right values for a particular category i can > pull out of the database the children of that category by using < and > >. this i understand. > > however if the children also have children, how do i just pull out the > first generation of children? > > eg. i wish to click on the winter category and just bring up the pants > and skirts categories ( i will be using simple text navigation) > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231053 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
