Re: hierarchical question - grabbing everything related

From: SpaceMarine <spacemarine_at_mailinator.com>
Date: Wed, 07 Nov 2007 14:33:02 -0800
Message-ID: <1194474782.906367.106950@19g2000hsx.googlegroups.com>

On Nov 7, 4:30 pm, SpaceMarine <spacemar..._at_mailinator.com> wrote:

> further, the circumstances are exactly what ive stated -- i have
> 20,000 product rows, w/ varying levels of hierarchies. i want to do a
> name-based search to get a subset of them, but i want it to list all
> of the returned rows' descendants too. one doesnt need to see all the
> past posts to respond to that notion, especially since nothing else
> has worked.

tho if your news provider doesnt have the OP, authored only two days ago on Nov 5, let me re-state -- the product table has your basic ObjectID & ParentID columns.

sm Received on Wed Nov 07 2007 - 16:33:02 CST