Jens,
I beg your pardon, but, what's the use of having such nested queries ?
In this sample, wouldn't:
select id, name
from employee_table
where department_id in (
select id
from department_table
)
be simpler ? Not to mention that a simple join would do this sample quite as
well (and faster too).
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Jens Lorenz [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 21, 2002 6:19 PM
> To: [EMAIL PROTECTED]
> Subject: Re: SQLTransformer, multiple execute-query siblings?
>
>
> ----- Original Message -----
> From: "Jens Lorenz" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 21, 2002 4:40 PM
> Subject: Re: SQLTransformer, multiple execute-query siblings?
>
>
> > From: "Argyn Kuketayev" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, June 21, 2002 4:27 PM
> > Subject: RE: SQLTransformer, multiple execute-query siblings?
> >
> >
> > > it doesn't support two nested queries on the same level of nesting, as
> > far
> > > as I remember after looking at C2.0.1 sources. I don't think it's
> fixed.
> > >
> > > Workaround is:
> > > 1. modify source codes
> >
> > The problem is, that it's not that easy. Transformer gets fed
> > SAX events and according to this spits out SAX events.
> >
> > If you want to reference the produced output you would have to
> > remember the output somehow which would make this beast far
> > more complex than it already is.
> >
> > If you really wanna do this, go ahead, but expect some work
> > ahead (SQLTransformer is kind of an orphaned anyway).
> > Otherwise go for XSP/ESQL.
> >
>
> I've to correct me on this one. My short looks into the source
> were obviously not enough ...
>
> This example is taken from
> http://xml.apache.org/cocoon/userdocs/transformers/sql-transformer.html
>
> <example>
>
> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
> <query name="department" >
> select id,name from department_table
> </query>
> <execute-query>
> <query name="employee">
> select id,name from employee_table where department_id =
> <ancestor-value sql:name="id" sql:level="1"/>
> </query>
> </execute-query>
> </execute-query>
> </page>
>
> </example>
>
> So according to the user docs this *is* possible. (Haven't testet it
> though)
>
>
> Regards,
>
>
> Jens
>
> --
>
> jens.lorenz at interface-projects dot de
>
> interface:projects GmbH \\|//
> Tolkewitzer Strasse 49 (o o)
> 01277 Dresden ~~~~oOOo~(_)~oOOo~~~~
> Germany
>
>
> ---------------------------------------------------------------------
> 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]>
