cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scherler <thorsten.scher...@wyona.org>
Subject Re: esql nested queries
Date Tue, 11 Mar 2003 14:08:42 GMT
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


Mime
View raw message