cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Myers <phan...@pirouline.sts.jhu.edu>
Subject Re: esql nested queries
Date Mon, 10 Mar 2003 16:45:19 GMT
Thorsten,

This message belongs on users.

You can't nest that way because as soon as you hit the nested execute-query
everything from the outer query is pushed onto a stack and is inaccessible.

You need a <xsp:logic>int ap_id = <esql:get-int column="id"/> before the 
inner query begins and then use <xsp:expr>ap_id</xsp:expr> in the inner query
to recall it.

Tim

On Mon, Mar 10, 2003 at 05:36:05PM +0100, 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: thorsten.scherler@weidmueller.de
> > http://www.weidmueller.de
> > 
> > 


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