----- 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]>
