cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From leo leonid <...@leonid.de>
Subject Re: esql nested queries
Date Mon, 10 Mar 2003 16:53:35 GMT
try this:

<esql:get-int column="ap_id" ancestor="1"/>
                              -----------

/Leo
On Montag, März 10, 2003, at 05:36  Uhr, 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
>>
>>
>


Mime
View raw message