cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: Nested esql queries.
Date Thu, 21 Dec 2000 06:30:36 GMT
On Fri, 15 Dec 2000, Roman Zamorski wrote:

> Hello,
>
> Is there possibility to do nested queries in esql when the inner query
> depend on the result of the outer one? I mean sth like this:
>
> <esql:query>select id,name from table1</esql:query>
> <esql:results>
>     <tag-outer>
>         <name><esql:get-string column="name"/></name>
>         ...
>             <esql:query>select name from table2
>             where id_table=<esql:get-int column="id"/></esql:query>
>             ...
>     </tag-outer>
> </esql:results>
>
> It really has to be done that way - i've tried with one-query version,
> and it works, but not exaclty like this above would...
>

yes. with the latest cvs version of esql, you can do nested queries. see
the sample.

- donald


Mime
View raw message