You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by "Hahn Kurt (CHA)" <ku...@etat.ge.ch> on 2002/06/24 15:30:13 UTC
Nested queries: Only 1 allowed per query?
Nested queries work well, but here, I tried to add a second one, and after
many (useless) tries, I'm suspecting that the SQL-transformer doesn't
support more than one nested query at once? Below is the query structure,
it works fine if I comment out either one of the nested queries. Trying to
execute them both results in an empty page. I didn't find any hints on this
in the documentation. Did anybody try something like this before?
Kurt
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
<query name="affairesPV">
<!-- Query goes here-->
</query>
<execute-query>
<query name="rapporteurs">
<!-- First nested query goes here-->
</query>
</execute-query>
<execute-query>
<query name="departement">
<!-- Second nested query goes here-->
</query>
</execute-query>
</execute-query>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Nested queries: Only 1 allowed per query?
Posted by Bertrand Delacretaz <bd...@codeconsult.ch>.
On Monday 24 June 2002 15:30, Hahn Kurt (CHA) wrote:
> I'm suspecting that the SQL-transformer doesn't
> support more than one nested query at once?
That's right - we had a discussion about this here at the end of last week,
see:
http://marc.theaimsgroup.com/?t=102466743100008&r=1&w=2
The alternatives are either to run several SQLTransformers chained in the
sitemap, or make a more complex SQL query and use XSLT downstream to create
the desired structure (grouping usually).
-Bertrand
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>