You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Tim Bachta <tb...@kopent.com> on 2003/06/11 16:21:46 UTC

Query within a query

I am trying to do a query nested within another query and am getting
errors, is it possible to do this and if so what am I doing wrong.  My
code is below:

       <esql:query>execute getReportsByRole
<xsp:expr>login</xsp:expr></esql:query>

       <esql:results>

         <reports>

           <esql:row-results>

         <report>

           <report-name>

             <esql:get-string column="Name"/>

           </report-name>

         </report>

         <esql:execute-query>

           <esql:query>execute getAttributesForReport <esql:get-int
column="1"/></esql:query>

           <esql:results>

             <parameters>

               <esql:row-results>

                 <parameter>

                   <parameter-name>

                     <esql:get-string column="2"/>

                   </parameter-name>

                 </parameter>

               </esql:row-results>

             </parameters>

           </esql:results>

         </esql:execute-query>

       </esql:row-results>

       </reports>

       </esql:results>

       </esql:execute-query>

 

Thanks for the help

 

Tim Bachta

 

 


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

Re: Query within a query

Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
On 11.Jun.2003 -- 09:21 AM, Tim Bachta wrote:
> I am trying to do a query nested within another query and am getting
> errors, is it possible to do this and if so what am I doing wrong.  My
> code is below:
> 
>        <esql:query>execute getReportsByRole
> <xsp:expr>login</xsp:expr></esql:query>

>          <esql:execute-query>
> 
            <esql:query>execute getAttributesForReport <esql:get-int column="1" ancestor="1"/></esql:query>

	Chris.
-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

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