If you write for Oracle you could use "connect by" clause of select statement.
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/state21b.htm#2065648
Vadim
> -----Original Message-----
> From: Max Larsson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 2:00 AM
> To: [EMAIL PROTECTED]
> Subject: AW: separation of content and logic
>
>
> Hi,
>
> > Now I want to generate a Menuestructure from database
> > entries in the way a filebrowser works, expand an entry on mouseclick,
> > on the second mouseclick collapse them (html links).
> > My first guess was to use nested select statements
> > to only get those entries I want to show (expanded or collapsed).
>
> I am trying to do the same. At the moment i am trying to use
> the nested set model from "SQL for smarties". See:
>
> http://www.dbmsmag.com/9603d06.html
> http://www.dbmsmag.com/9604d06.html
> http://www.dbmsmag.com/9605d06.html
>
> > As I thought further may be it would be better in the xsp
> > to always retrieve all items from the database
> > and then decide in the stylesheet which entries to
> > show and which not (e.g. by session attributes).
> > But in a xsl I cann't use <xsp:logic>
>
> After thinking a lot i decided to let xsp retrieve
> the complete menu structure and let the xsl stylesheet
> decide which menu items are collapsed or expandended.
> To that i will give the xsl stylesheet a parameter,
> which contains all the ids of the menuitems, wich shall
> be expanded. That's my idea, if it works have to
> be proved.
>
> Max
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
