try this:
<esql:get-int column="ap_id" ancestor="1"/>
-----------
/Leo
On Montag, März 10, 2003, at 05:36 Uhr, Scherler, Thorsten wrote:
Hello group,
I am using cocoon 2.0.4.
I tried the following the nested esql (not working):
<esql:connection>
<esql:pool>INSTA</esql:pool>
<esql:execute-query>
<esql:query>
select * from xml_verkauf
</esql:query>
<esql:results>
<esql:row-results>
<data>
<client>
<ep1>
<esql:get-int column="ap_id"/>
</ep1>
</client>
<aps>
<esql:execute-query>
<esql:query>
select * from ap_tab where ap_id =<esql:get-int
column="ap_id"/>
</esql:query>
<esql:results>
<esql:row-results>
<ap>
<esql:get-columns/>
</ap>
</esql:row-results>
</esql:results>
<esql:no-results><no-results/></esql:no-results>
<esql:error-results/>
</esql:execute-query>
</aps>
</data>
</esql:row-results>
</esql:results>
<esql:no-results/>
<esql:error-results/>
</esql:execute-query>
</esql:connection>
As soon as I change
...
select * from ap_tab where ap_id =1
I can nest the query!
Why can I not use <esql:get-int column="ap_id"/> ?
King regards
Mit freundlichem Gruss,
Thorsten Scherler
Marketing / Telefonmarketing
Weidmüller GmbH & Co.
P.O. Box 2807
33058 Paderborn
Tel.:+ 49 - 5252-960-350
Fax:+ 49 - 5252-960-116
eMail: [EMAIL PROTECTED]
http://www.weidmueller.de
