cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vadim Gritsenko" <vgritse...@hns.com>
Subject RE: News site with XSP and SQL. (fwd)
Date Tue, 09 Jan 2001 21:27:50 GMT
This is called "hierarchical query clause", see
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.
817/a85397/state21b.htm for details.

request to select all news and build tree can look like:

SELECT * FROM news START WITH parentid IS NULL CONNECT BY PRIOR id =
parentid;


Vadim

> -----Original Message-----
> From: Donald Ball [mailto:balld@webslingerZ.com]
> Sent: Tuesday, January 09, 2001 13:49
> To: cocoon-users@xml.apache.org
> Subject: RE: News site with XSP and SQL. (fwd)
>
>
> On Tue, 9 Jan 2001, Vadim Gritsenko wrote:
>
> > If you are doing this on Oracle, Oracle can build tree of
> comments for you.
> > In SELECT, you should just connect parent record with childs.
> > Can this help?
>
> what would this query look like?
>
> - donald
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org



Mime
View raw message