cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: rendering hierarchical tables - XSP/SQL?
Date Tue, 28 Nov 2000 00:01:39 GMT
On Mon, 27 Nov 2000, Markus Wagner wrote:

> Hi,
> 
> I have a database with a hierarchical table "Category" to represent a
> tree of categories. Primary key is "idx", while "parent" is a reference
> into the same table and should point to the parent category.
> 
> Is it possible to write a xsp page or use a sql taglib to render the
> tree?
> 
> I am thinking of something like this.
> 
> Initially, make a query "SELECT ... WHERE parent = NULL", and let it
> render using the sql taglib. But then, for each of the result elements,
> do a "SELECT ... WHERE parent = <current>.idx".

you want to use the esql logicsheet from cvs. it can do nested queries.

- donald


Mime
View raw message