result-set inside a no-results

> Hello again,
>  
> Curious if this particular way of doing things is supported.
>  
> I'm doing a query in an XPL file, in the <result-set> I'm building an
> XML file, however, in the <no-results> I'm doing another <execute> that
> runs another <query> which builds a similar XML file in its own
> <result-set>.
>  
> I thought it was working ok, but turns out it isn't.  If I send it data
> that causes it to go into the <no-results> everything seems fine.  But
> when I send it data that shouldn't go into the no-results block, it
> still seems to be executing that query and adding the second XML file to
> the first (giving me two root elements).
>  
> Why is Orbeon executing queries in the <no-results> block if there were
> results from the previous <result-set>?
>  
> Removing the <no-results> block entirely works, and removing the
> <result-set> from the <no-results> also works (but I'm assuming that the
> SQL in the <no-results> is still being run.
>  
> Here's an example of my SQL XPL file:
>  
> <p:processor name="oxf:sql">
>   <p:output name="data" id="data" />
>   <p:input name="data" href="#instance"/>
>   <p:input name="datasource" href="/external/datasource-sql.xml" />
>   <p:input name="config">
>    <sql:config>
>     <sql:connection>
>      <sql:execute>
>       <sql:query>
> QUERY 1
>       </sql:query>
>       <sql:result-set>
>        <root>
>         <sql:row-iterator>
>          <item>
>           <column1><sql:get-column-value type="xs:string"
> column="col1"/></column1>
>           <column2><sql:get-column-value type="xs:string"
> column="col2"/></column2>
>          </item>
>         </sql:row-iterator>
>        </root>
>       </sql:result-set>
>       <sql:no-results>
>        <sql:execute>
>         <sql:query>
> QUERY 2 ONLY RUN WHEN NO RESULTS FROM ABOVE
>         </sql:query>
>         <sql:result-set>
>          <root>
>           <sql:row-iterator>
>            <item>
>             <column1><sql:get-column-value type="xs:string"
> column="col1"/></column1>
>             <column2><sql:get-column-value type="xs:string"
> column="col2"/></column2>
>            </item>
>           </sql:row-iterator>
>          </root>
>         </sql:result-set>
>        </sql:execute>
>       </sql:no-results>
>      </sql:execute>
>     </sql:connection>
>    </sql:config>
>   </p:input>
>  </p:processor>
>  
> Appreciate any insight,
>  
> Jay
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

> Hello again,
>
> Curious if this particular way of doing things is supported.
>
> I'm doing a query in an XPL file, in the <result-set> I'm building an
> XML file, however, in the <no-results> I'm doing another <execute> that
> runs another <query> which builds a similar XML file in its own
> <result-set>.
>
> I thought it was working ok, but turns out it isn't.  If I send it data
> that causes it to go into the <no-results> everything seems fine.  But
> when I send it data that shouldn't go into the no-results block, it
> still seems to be executing that query and adding the second XML file to
> the first (giving me two root elements).
>
> Why is Orbeon executing queries in the <no-results> block if there were
> results from the previous <result-set>?
>
> Removing the <no-results> block entirely works, and removing the
> <result-set> from the <no-results> also works (but I'm assuming that the
> SQL in the <no-results> is still being run.
>
> Here's an example of my SQL XPL file:
>
> <p:processor name="oxf:sql">
>   <p:output name="data" id="data" />
>   <p:input name="data" href="#instance"/>
>   <p:input name="datasource" href="/external/datasource-sql.xml" />
>   <p:input name="config">
>    <sql:config>
>     <sql:connection>
>      <sql:execute>
>       <sql:query>
> QUERY 1
>       </sql:query>
>       <sql:result-set>
>        <root>
>         <sql:row-iterator>
>          <item>
>           <column1><sql:get-column-value type="xs:string"
> column="col1"/></column1>
>           <column2><sql:get-column-value type="xs:string"
> column="col2"/></column2>
>          </item>
>         </sql:row-iterator>
>        </root>
>       </sql:result-set>
>       <sql:no-results>
>        <sql:execute>
>         <sql:query>
> QUERY 2 ONLY RUN WHEN NO RESULTS FROM ABOVE
>         </sql:query>
>         <sql:result-set>
>          <root>
>           <sql:row-iterator>
>            <item>
>             <column1><sql:get-column-value type="xs:string"
> column="col1"/></column1>
>             <column2><sql:get-column-value type="xs:string"
> column="col2"/></column2>
>            </item>
>           </sql:row-iterator>
>          </root>
>         </sql:result-set>
>        </sql:execute>
>       </sql:no-results>
>      </sql:execute>
>     </sql:connection>
>    </sql:config>
>   </p:input>
>  </p:processor>
>
> Appreciate any insight,
>
> Jay
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws