cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markus Wagner <mawag...@mail.uni-mainz.de>
Subject rendering hierarchical tables - XSP/SQL?
Date Mon, 27 Nov 2000 17:58:40 GMT
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".

Any hints?

Thank you,

Markus Wagner



Mime
View raw message