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]>
