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