Query within a query

[Tim Bachta]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]