cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Rossel <lol...@lolive.net>
Subject ESQL doc.
Date Thu, 14 Feb 2002 14:36:44 GMT
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message