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
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Bertrand Delacretaz [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 21, 2002 3:48 PM
> To: [EMAIL PROTECTED]
> 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: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
