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