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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
