cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kai.Reh...@pass-consulting.com
Subject esql:max-row esql:skip-row
Date Wed, 22 Aug 2001 08:22:11 GMT
Hi,

can someone please exlpain how to use the <esql:max-row> and <esql:skip-row>
attributes?

<esql:connection>
<esql:pool>mypool</esql:pool>
<esql:execute-query>
<esql:query>
select d.docid, d.title, d.author, h.date, h.histid from doc as d, history
as h
where h.docid = d.docid and d.docid != 0 and <xsp:expr>noAdmin</xsp:expr>
h.histid = (select max(h2.histid) from history as h2 where h2.docid =
d.docid) order by <xsp:expr>Order</xsp:expr>
</esql:query>
<esql:results>
<esql:row-results>
<docid><esql:get-int column="docid"/></docid>
<title><esql:get-string column="title"/></title>
<author><esql:get-string column="author"/></author>
<date><xsp:logic>strDate = (new
SimpleDateFormat("dd.MM.yyyy").format(<esql:get-date
column="date"/>));</xsp:logic><xsp:expr>strDate</xsp:expr></date>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>


I'm using Cocoon 2.0b1 and IBM DB2

Thanks a lot 

Kai 

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message