You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Olivier Rossel <lo...@lolive.net> on 2002/02/14 15:36:44 UTC
ESQL doc.
I read the archives of the mailing-list about ESQL and nested queries.
I read an interesting thing about "ancestor" in the declaration of inner
requests.
But I can find no documentation at all, about that point.
Anyone has a link?
Any docs has been updated in addition to the page available at:
http://xml.apache.org/cocoon/userdocs/xsp/esql.html ?
My problem is to have something like:
<query1> select foobar, foo, bar from table1;
for each foobar: {
<query2> select * from table2 where field1=<current-value-of foobar>;
for each barfoo (selected by the previous query, inside the '*'): {
<query3> select * from table3 where field1=<current-value-of barfoo;
}
<get-columns-of query2>
<get-columns-foo-of query1>
<get-columns-bar-of query1>
}
I do not plan to use a single complicated SQL request in order to have a
flat XML
output.
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: ESQL doc.
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 14.Feb.2002 -- 03:36 PM, Olivier Rossel wrote:
> I read the archives of the mailing-list about ESQL and nested queries.
> I read an interesting thing about "ancestor" in the declaration of inner
> requests.
> But I can find no documentation at all, about that point.
>
> Anyone has a link?
> Any docs has been updated in addition to the page available at:
> http://xml.apache.org/cocoon/userdocs/xsp/esql.html ?
>
> My problem is to have something like:
>
> <query1> select foobar, foo, bar from table1;
> for each foobar: {
> <query2> select * from table2 where field1=<current-value-of foobar>;
> for each barfoo (selected by the previous query, inside the '*'): {
> <query3> select * from table3 where field1=<current-value-of barfoo;
> }
<esql:get-columns ancestor="1"/>
<esql:get-columns/>
<esql:get-columns ancestor="2"/>
> }
>
> I do not plan to use a single complicated SQL request in order to have a
> flat XML
> output.
Have a look at the esql docs and look at the grouping example. It
might suit your needs. The ancestor feature is very simple: add the
attribute "ancestor" with the count of queries to any
esql:get... element.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>