cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scherler, Thorsten" <Thorsten.Scher...@weidmueller.de>
Subject esql nested queries
Date Mon, 10 Mar 2003 16:36:05 GMT
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: thorsten.scherler@weidmueller.de
> http://www.weidmueller.de
> 
> 

Mime
View raw message