Return-Path: 
 <cocoon-users-return-27625-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 16512 invoked by uid 500); 16 Jan 2002 16:16:52 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 16491 invoked from network); 16 Jan 2002 16:16:51 -0000
X-Authentication-Warning: matrix.intranet.neissware.de: Host [192.168.1.67]
 claimed to be rainyday.de
Message-ID: <3C45A42B.9070900@rainyday.de>
Date: Wed, 16 Jan 2002 17:02:51 +0100
From: SunnyDay <sunnyday@rainyday.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-DE;
 rv:0.9.2) Gecko/20010726 Netscape6/6.1
X-Accept-Language: de-DE
MIME-Version: 1.0
To: cocoon-users@xml.apache.org
Subject: Re: [C2] esql: using query results in another query
References: <27AFC41AECE2D4118FA000D0B7C57054010013D1@mx02.wide.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

<esql:get-string column="id" ancestor="1"/>

should work

CU
   Harald


fred.tsang@widelearning.com wrote:

> I was wondering if anyone has used one esql result field in another query.
> What I thought it should look like is:
> 
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <xsp:page
>    language="java"
>    xmlns:xsp="http://apache.org/xsp"
>    xmlns:esql="http://apache.org/cocoon/SQL/v2"
> 
>   <page>
>     <content>
>       <esql:connection>
>         <esql:pool>pooledConnect</esql:pool>
>         <department>
>         <esql:execute-query>
>           <esql:query>
>             select id from department_table
>           </esql:query>
>           <!-- note embedded query here -->
>           <esql:execute-query>
>             <esq:query>
>               select id,name 
>               from employee_table 
>               where department_id = <ancestor-value esql:name="id"
> esql:level="1"/>
>             </esql:query>
>             <esql:results>
>               <esql:row-results>
>                 <employee>
>                   <employeeId><esql:get-string column="id"/></employeeId>
>                   <employeeName><esql:get-string
> column="name"/></employeeName>
>                 </employee>
>               </esql:row-results>
>             </esql:results>
>           </esql:execute-query>
>         </esql:execute-query>
>         </department>
>       </esql:connection>
>     </content>
>   </page>
> </xsp:page>
> 
> I would expect somthing like this to output:
> 
> <department>
>   <employeeId>1</employeeId>
>   <employeeName>Joe</employeeName>
>   <employeeId>2</employeeId>
>   <employeeName>John</employeeName>
>   <employeeId>3</employeeId>
>   <employeeName>Jack</employeeName>
> </department>
> <department>
>   <employeeId>4</employeeId>
>   <employeeName>Mary</employeeName>
>   <employeeId>5</employeeId>
>   <employeeName>Bob</employeeName>
>   <employeeId>6</employeeId>
>   <employeeName>Paul</employeeName>
> </department>
> 
> I'd also like to identify the department id with an attribute or an
> <id></id> field, but I'm not sure how.  If anyone can guide me in this, I
> would really appreciate it.  The example in docs/samples/sql/sql-page.xml is
> out of date I think, and the esql example is too simple.
> 
> Thanks in advance,
> Fred
> 
> 
> Legal Disclaimer 
> 
> This message contains confidential information and is intended only for
> the individual named.  If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail.  Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and delete
> this e-mail from your system.
> mail transmission cannot be guaranteed to be secure or error-free as
> information could be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete, or contain viruses.  The sender therefore does not accept
> liability for any errors or omissions in the contents of this message that
> arise as a result of e-mail transmission.  If verification is required
> please request a hard-copy version.  This message is provided for
> informational purposes only.
> our website at: http://www.widelearning.com
> 
> Wide Learning is a trading name of Wide Multimedia Ltd Registered office:
> 33-41 Dallington Street, London EC1V 0BB
> Company number: 3339664 VAT number: 690 8399 83
> 
> 
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
> 
> To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> 
> 



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>