Re: hierarchical query - returning a treewalked subset

On Nov 8, 2:43 pm, Brian Tkatch <N/A> wrote:

> >> Why does it not work? What error have you been getting?
>
> >it returns duplicate rows. the reason being (as far as i can tell), is
> >that it first returns every product row that matches the name-criteria
> >("test*") as a LEVEL 1; then, it digs up all children for each
> >returned row and builds levels under them. this can provide for
> >misleading duplicates because a product may be a LEVEL 3 child, yet is
> >now also returned as a LEVEL 1 row, which it is truly not.
>
> >currently im having to re-loop the returned resultset, and remove any
> >LEVEL 1 row that is also defined as a LEVEL 2+.
>
> >make sense?
>
> Perhaps the START WITH needs to be defined to choose only a level 1.

nope.

sm Received on Thu Nov 08 2007 - 16:53:24 CST