esql row count

[Anna Bikkina <an...@pinksheets.com>]

Hi,

I am trying to get the count of number of rows returned in a query using esql. 
Is there something like esql:get-row-count. 

Any idea how I can get the number of rows using esql.

Thanks,

Anna.


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

Re: esql row count

[olivier demah <od...@messagio.com>]

Anna Bikkina a écrit :

>Hi,
>
>I am trying to get the count of number of rows returned in a query using esql. 
>Is there something like esql:get-row-count. 
>
>Any idea how I can get the number of rows using esql.
>
>  
>
you might find something here

http://cocoon.apache.org/2.1/userdocs/xsp/esql.html

or may be a simple SELECT count(*) as total FROM table .... 
and then
<total><esql:get-int column="total"/></total>


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