cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From o...@kompuart.pl (Leszek Gawron)
Subject Re: ESQL problem - current cocoon HEAD
Date Thu, 09 Jan 2003 10:05:42 GMT
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            //  \\
        \_\\  //_/      ouzo@vip.net.pl          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


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


Mime
View raw message