Return-Path: 
 <cocoon-dev-return-38049-apmail-xml-cocoon-dev-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org
Received: (qmail 35816 invoked by uid 500); 10 Mar 2003 16:36:20 -0000
Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-dev-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-dev-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-dev@xml.apache.org>
Reply-To: cocoon-dev@xml.apache.org
Delivered-To: mailing list cocoon-dev@xml.apache.org
Received: (qmail 35799 invoked from network); 10 Mar 2003 16:36:20 -0000
Received: from unknown (HELO srvde019.weidmueller.com) (217.244.7.240)
  by daedalus.apache.org with SMTP; 10 Mar 2003 16:36:20 -0000
Received: FROM srvde018.weidmueller.com BY srvde019.weidmueller.com ;
 Mon Mar 10 17:36:39 2003 +0100
Received: from srvde016.weidmueller.com ([10.1.23.40]) by
 srvde018.weidmueller.com with Microsoft SMTPSVC(5.0.2195.5329);
	 Mon, 10 Mar 2003 17:36:05 +0100
X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: esql nested queries
Date: Mon, 10 Mar 2003 17:36:05 +0100
Message-ID: <3671ACD9D9D5C648A6181F8048DC9A5D095787@srvde016.weidmueller.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: esql nested queries
Thread-Index: AcLnIy4QAv99QbTQQZyhv7Ion9biXg==
From: "Scherler, Thorsten" <Thorsten.Scherler@weidmueller.de>
To: "Cocoon-Dev (E-Mail)" <cocoon-dev@xml.apache.org>
X-OriginalArrivalTime: 10 Mar 2003 16:36:05.0762 (UTC)
 FILETIME=[256DCE20:01C2E723]
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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=20
         </esql:query>
<esql:results>
<esql:row-results>
<data>
<client>
<ep1>
<esql:get-int column=3D"ap_id"/>
</ep1>
</client>
<aps>
<esql:execute-query>
<esql:query>
                  select * from ap_tab where ap_id =3D<esql:get-int =
column=3D"ap_id"/>                =20
</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=20
...
                  select * from ap_tab where ap_id =3D1=20
 I can nest the query!

Why can I not use <esql:get-int column=3D"ap_id"/>     ?

King regards

> Mit freundlichem Gruss,
>=20
> Thorsten Scherler
> Marketing / Telefonmarketing
>=20
> Weidm=FCller 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
>=20
>=20