On Thu, Jan 09, 2003 at 11:03:38AM +0100, Torsten Curdt wrote:
> >No I don't.
> >
> >Shouldnt JdbcEsqlQuery.getResultRows() look like this (just a guess - I'm
> >not
> >experienced with jdbc):
> >
> >public void getResultRows() throws SQLException {
> > if ( getSkipRows() > 0 )
> > getResultSet().absolute(getSkipRows());
> > setPosition(getSkipRows());
> > }
> >
> >current version does not check getSkipRows() for zero equality
>
> Do you use the esql:max-rows?
no - it's the most simple query you can imagine:
<esql:connection>
<esql:pool>cdn</esql:pool>
<esql:execute-query>
<esql:query>
select id, ope_opeid from gemini_users where device_id =
'<xsp:expr>username</xsp:expr>'
</esql:query>
<esql:results>
<esql:row-results>
<xsp-session:set-attribute name="userid"><esql:get-string
column="id"/></xsp-session:set-attribute>
<xsp-session:set-attribute name="opeid"><esql:get-string
column="ope_opeid"/></xsp-session:set-attribute>
<action:set-success/>
</esql:row-results>
</esql:results>
<esql:no-results>
<xsp-session:invalidate/>
<action:set-failure/>
</esql:no-results>
</esql:execute-query>
</esql:connection>
ouzo
--
__
| / \ | Leszek Gawron // \\
\_\\ //_/ [EMAIL PROTECTED] _\\()//_
.'/()\'. Phone: +48(600)341118 / // \\ \
\\ // recursive: adj; see recursive | \__/ |
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
