You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Tim Myers <ph...@pirouline.sts.jhu.edu> on 2003/03/10 17:45:19 UTC
Re: esql nested queries
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
Re: esql nested queries
Posted by Scherler <th...@wyona.org>.
Tim,
thank you very much!
belongs on users. <- you are right (the first to dev was a mistake)
Tim Myers wrote:
>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
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org