Re: reusing a result set with esql

[Adrian Petru Dimulescu]

> I would like to reuse a result set in an XSP page when doing an esql
> query (I want to be able to reiterate throgh the returned  rows). Is
> there a way to do that ?
Hello again, let me reformulate this question, I guess it's not very 
explicit (hope it's not that plainly stupid):

I have a simple esql sequence in an XSP file:

<esql:connection>
  <esql:pool>kercash-warehouse</esql:pool>
  <esql:execute-query>
    <esql:query>SELECT part_id, part_nom FROM partenaire</esql:query>
    <esql:results>
        <esql:row-results>
        ... do something
        </esql:row-results>
    </esql:results>
    <esql:no-results><p>Sorry, no results!</p></esql:no-results>
    <esql:error-results>An error occurred</esql:error-results>
  </esql:execute-query>
</esql:connection>

I wish I were able, after a first iteration through the result set with 
<esql:results>, to re-iterate the same resultset without having to 
reexecute the query. Is that possible anybody tried it ?

Thanks for your ideas!
Adrian.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]