You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@cocoon.apache.org by Frederic Alluin <fr...@webmedia.es> on 2000/10/02 18:09:34 UTC

multi esql query

Hi,
I need to make something like that:
<esql:query>SELECT * FROM movie WHERE id='2'</esql:query>
   <esql:results>
    <movie>
        .....
        <esql:query>SELECT name FROM actor WHERE id='7'</esql:query>
        <esql:results>
        <actor> ....... </actor>
        </esql:results>
        .....
    </movie>
   </esql:results>

But it doesn't work!!!!! ;-)
Anybody already made anything similar ????

Thanks a lot

Fred

Re: multi esql query

Posted by Frederic Alluin <fr...@webmedia.es>.

oups.... everything is in the examples sql files.
sorry.
Fred

Frederic Alluin wrote:

> Hi,
> I need to make something like that:
> <esql:query>SELECT * FROM movie WHERE id='2'</esql:query>
>    <esql:results>
>     <movie>
>         .....
>         <esql:query>SELECT name FROM actor WHERE id='7'</esql:query>
>         <esql:results>
>         <actor> ....... </actor>
>         </esql:results>
>         .....
>     </movie>
>    </esql:results>
>
> But it doesn't work!!!!! ;-)
> Anybody already made anything similar ????
>
> Thanks a lot
>
> Fred
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org