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: [EMAIL PROTECTED] > > http://www.weidmueller.de > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]