Re: hierarchical question - grabbing everything related

On Nov 6, 7:13 am, Steve Howard <stevedhow..._at_gmail.com> wrote:
> Are you asking that if Steve is the parent, and Abigail and Madeline
> are the children, that you also want to see Abigail if Madeline is
> selected?
>
> Steve
> / \
> / \
> | |
> Abigail Madeline

no. what im saying is... if somebody does a search to find rows matching "Mad%", and it finds one, i need to return not only that row but also Madeline's parent row (Steve). and if Steve has a parent, i need to return *that row* to. basically -- for a given name-criteria, i need to find *all* ancestors to an indefinite degree.

this is because the 3rd party app i am working with breaks if it comes across an orphaned row -- that is, if any rows reference a ParentID, i need to also have those parent-rows present. and if those parent-rows have parents, they need to be present... etc.

its like a reverse treewalk. but for a name-criteria search.

sm Received on Tue Nov 06 2007 - 09:52:36 CST