If you are selecting data from a database and that database happens to be Oracle look at the connect by clause. It does everything you are looking for.
eg select name, id, level from yourtable where start with id=0 /* or put whatever id you want to start looking from */ connect by prior id = parent_id ; Scott. Frank Mancini <frank69m@HOTMAIL To: [EMAIL PROTECTED] .COM> cc: Sent by: A Subject: Re: Please help! Recursive loop in JSP mailing list about Java Server Pages specification and reference <JSP-INTEREST@JAV A.SUN.COM> . 11/12/01 06:16 PM Please respond to A mailing list about Java Server Pages specification and reference Thanks Joe, ya I want more info. I think we will choose the narrower and deeper family. Let me know if you have anymore ideas. >From: Joe Cheng <[EMAIL PROTECTED]> >Reply-To: A mailing list about Java Server Pages specification and >reference <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: Please help! Recursive loop in JSP >Date: Mon, 12 Nov 2001 17:21:24 -0500 > >I had to do this once... fun problem. > >First of all, forget about doing it "in JSP"... you should use Java classes >for this. > >Two ways to do it, IMO. If you have a large and flat dataset, i.e. many >records in the table but no trees that go more than a few generations deep, >you can have a method in the Person object of signature: > public Person[] getAllChildren() >that queries for all the children, and calls getAllChildren() on them, and >adds the results into some kind of vector. However, that will result in >many calls to the database because each getAllChildren() call will cost you >a query. > >If the dataset is narrower and deeper, i.e. a few very deep families, you >can create a method that loads up all the data in one query and then >constructs the objects using a method similar to the above. The advantage >of this is that you only have to run the query once; the disadvantages are >that you have loaded all this data that may or may not be used. > >Let me know if you need more detail... > >-jmc > >-----Original Message----- >From: Frank Mancini [mailto:[EMAIL PROTECTED]] >Sent: Monday, November 12, 2001 5:04 PM >To: [EMAIL PROTECTED] >Subject: Please help! Recursive loop in JSP > > >I have a recursive looping problem here. > >For example, say I have this table > >id, name, parent > >1,john,4 >2,bill,3 >3,cathy,4 >4,jackie,0 >5,jeff,4 >6,joe,7 >7,amy,0 > >Essentially, > >jackie doesn't have a parent, but has john, jeff and cathy as children. >bill >is the child of cathy and thus jackies grandchild. > > >How would I do this query such that I say I want to see all the children >(including everyone below him/her) below, say jackie...this is really a >self >join to oneself with an unknown number of levels below. > >How would I do this in jsp do display all of jackies relatives below her? > >_________________________________________________________________ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > =========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >DIGEST". >Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > > =========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >DIGEST". >Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com