You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Bertrand Delacretaz <bd...@codeconsult.ch> on 2002/06/21 15:48:12 UTC
SQLTransformer, multiple execute-query siblings?
Hi SQLers,
If I understand the SQLTransformer code correctly, this construct is not
supported:
<execute-query>
<query>select A</query>
<execute-query>
<query>select B using values from select A in where clause</query>
<execute-query>
<!-- is a second one here supported? -->
<execute-query>
<query>select C using values from select A in where clause</query>
<execute-query>
<execute-query>
Can someone confirm this, and is there a workaround other than chaining
multiple SQLTransformers with XSLT to generate sub-queries?
--
Bertrand Delacrétaz (codeconsult.ch, jfor.org)
buzzwords: XML, java, XSLT, cocoon, mentoring/teaching/coding.
disclaimer: eternity is very long. mostly towards the end. get ready.
---------------------------------------------------------------------
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: SQLTransformer, multiple execute-query siblings?
Posted by Luca Morandini <lu...@tin.it>.
Bertrand,
could, just possibly, a sub-select fit the bill ?
something like:
SELECT Name
FROM Employee
WHERE Ssn IN (
SELECT DISTINCT PMSsn
FROM Projects
WHERE Status = 'open'
)
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Bertrand Delacretaz [mailto:bdelacretaz@codeconsult.ch]
> Sent: Friday, June 21, 2002 3:48 PM
> To: cocoon-users@xml.apache.org
> Subject: SQLTransformer, multiple execute-query siblings?
>
>
> Hi SQLers,
>
> If I understand the SQLTransformer code correctly, this construct is not
> supported:
>
> <execute-query>
>
> <query>select A</query>
>
> <execute-query>
> <query>select B using values from select A in where clause</query>
> <execute-query>
>
> <!-- is a second one here supported? -->
> <execute-query>
> <query>select C using values from select A in where clause</query>
> <execute-query>
>
> <execute-query>
>
> Can someone confirm this, and is there a workaround other than chaining
> multiple SQLTransformers with XSLT to generate sub-queries?
>
> --
> Bertrand Delacrétaz (codeconsult.ch, jfor.org)
>
> buzzwords: XML, java, XSLT, cocoon, mentoring/teaching/coding.
> disclaimer: eternity is very long. mostly towards the end. get ready.
>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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>
>
---------------------------------------------------------------------
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>