Re: Please help! Recursive loop in JSP

2001-11-13 Thread Scott Watson
= parent_id ; Scott. Frank Mancini frank69m@HOTMAILTo: [EMAIL PROTECTED] .COMcc: Sent by: A Subject: Re: Please help! Recursive loop in JSP

Re: Please help! Recursive loop in JSP

2001-11-13 Thread Joe Cheng
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. that's really interesting, I've never heard of connect by. can you or Ross provide more detail, i.e. what does the resulting recordset look

Re: Please help! Recursive loop in JSP

2001-11-13 Thread Kenny Dao
Hi does any know or have an example of how to store multiple vectors inside a hashtable? thank Ken 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

Re: Please help! Recursive loop in JSP

2001-11-13 Thread Chen, Gin
PROTECTED] Subject: Re: Please help! Recursive loop in JSP Hi does any know or have an example of how to store multiple vectors inside a hashtable? thank Ken http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp

Re: Please help! Recursive loop in JSP

2001-11-13 Thread Scott Watson
. Scott. Joe Cheng [EMAIL PROTECTED]To: [EMAIL PROTECTED] Sent by: A cc: mailing list Subject: Re: Please help! Recursive loop in JSP about Java Server

Re: Please help! Recursive loop in JSP

2001-11-13 Thread Chen, Gin
: Tuesday, November 13, 2001 2:51 PM To: [EMAIL PROTECTED] Subject: Re: Please help! Recursive loop in JSP Joe, You can get more information at otn.oracle.com or do a search on google. I believe these type of queries are called Hierarchical Queries. Your DBA should be able to provide you

Re: Please help! Recursive loop in JSP

2001-11-13 Thread Chen, Gin
:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 2:51 PM To: [EMAIL PROTECTED] Subject: Re: Please help! Recursive loop in JSP Joe, You can get more information at otn.oracle.com or do a search on google. I believe these type of queries are called Hierarchical Queries. Your DBA should be able

Re: Please help! Recursive loop in JSP

2001-11-13 Thread Scott Watson
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

Please help! Recursive loop in JSP

2001-11-12 Thread Frank Mancini
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

Re: Please help! Recursive loop in JSP

2001-11-12 Thread Joe Cheng
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

Re: Please help! Recursive loop in JSP

2001-11-12 Thread Jean-Francois Pinero
Title: RE: Please help! Recursive loop in JSP I haven't tested the code and wrote it in less than 10 minutes so you might want to try it out first but solution should be along one of those lines... Code below is probably a combination of JSP, asp, vb and java so use jsp equivalent of course

Re: Please help! Recursive loop in JSP

2001-11-12 Thread Chris Tucker
:[EMAIL PROTECTED]]On Behalf Of Frank Mancini Sent: Monday, November 12, 2001 2: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

Re: Please help! Recursive loop in JSP

2001-11-12 Thread Jean-Francois Pinero
Title: RE: Please help! Recursive loop in JSP I meant to say use java equivalent, not jsp equivalent because a bean should be used like Chris just mentioned... -Original Message-From: Jean-Francois Pinero [mailto:[EMAIL PROTECTED]]Sent: Monday, November 12, 2001 5:29 PMTo: [EMAIL

Re: Please help! Recursive loop in JSP

2001-11-12 Thread Frank Mancini
: 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

Re: Please help! Recursive loop in JSP

2001-11-12 Thread Ross Bonner
14:04:14 -0800 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

Re: Please help! Recursive loop in JSP

2001-11-12 Thread Ross Bonner
1. The easy way if you are using an oracle database, this gets them all in one query select name from table start with id = ? connect by parent = prior id 2. use a stack Brief example... class Person { int id; String name; Person(int id, String name) { this.id = id; this.name =