Torsten: Thanks for the quick response. You are correct about the set of values for the <esql:use-limit-clause>. I verified them by slogging through the EsqlQuery.java and EsqlConnection.java source code. Thanks.
As for the ESQL schema, maybe as an after effect of researching the ESQL logichsheet, I should rewrite the esql.xsd. After this chapter, I should be very intimate with logicsheets and the ESQL logicsheet in particular. Who is responsible for the ESQL logicsheet? Regards, Mark Gaither PS. I'm working on getting our book's Cocoon 2 examples onto the publisher's new Cocoon based web site for the public to view and use. I will make an annoucement to this mailing list once they are in place. ----- Original Message ----- From: "Torsten Curdt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 3:56 PM Subject: Re: Cocoon 2 Builtin-Logicsheet Definitions On Tuesday 14 May 2002 22:37, Mark Gaither wrote: > I'm a co-author on a book entitled "Cocoon 2 Programming: Web Publishing > with Java and XML". > > I writing a chapter entitled "XSP LogicSheets". In this chapter, I'm > cataloging all > of the built-in logicsheets. I'm having problems determining some of the > definitions of > elements of the ESQL logicsheet. For example, what is: > > <esql:use-limit-clause> Hi, Mark, that's actually for telling ESQL which database you have. Postgres and MySQL have an explicit limit clause while most other vendors (very unfortunately) don't have such clauses. It goes hand-in-hand with the max-rows and skip-rows settings. You can use the following values: mysql, postgres, jdbc, auto (IIRC - please crosscheck) "mysql" uses the native mysql limit clause "postgres" the postgres clause "jdbc" uses what is possible with jdbc (let's the vendor driver do the work) "auto" tries to find the correct one (IIRC from the driver url) > I have picked apart the esql.xsl and the esql.xsd but I have yet to find a > lot of > documentation other than what is in the Cocoon 2 documentation. I know is quite out of date... > Also, why is the included esql.xsd (schema definition) not complete? In > other words, > why aren't the esql elements autocommit and use-limit-clause not defined in > the > esql.xsd? Well, we didn't add them yet (easy like that ;-) ...but seriously They *should* be in there but... you know... documentation... none of the developers wants to do it ;-) I fear the xsd could be quite out of date. But feel free to ask :-) Cheers -- Torsten --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
