cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markus Wagner <>
Subject rendering hierarchical tables - XSP/SQL?
Date Mon, 27 Nov 2000 17:58:40 GMT

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

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

View raw message