On 26.Sep.2002 -- 09:37 AM, Zein Dowe wrote:
> Hi,
>
> i got some questions about the esql logicsheet from cocoon.
> I suppose the first one is easy to answer:
>
> 1. How can i count the number of rows from the result of my query?
There's a row-count tag but it works only with some cases. You saftest
bet is to count the rows as you retrieve them. If you need paging or
something, esql provides a limit clause. See docs and search this list.
> The second one seems quit more difficult to me (but i am a newbie and know
> nothing ;-):
>
> 2. How can I handle the exception which is thrown if the database connection
> fails?
You can override the error handler in your sitemap.
Other errors can be handled in the <esql:error-results/>
block. Connection errors not, I'm afraid.
Chris.
Please follow up summarizing your problem and which suggested solution
/ information worked for you when you consider your problem
solved. Add "SUMMARY: " to the subject line. This will make FAQ
generation and searching the list easier. In addition, it makes
helping you more fun. Thank you.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
