Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-users@xml.apache.org
Content-Type: text/plain;
  charset="iso-8859-1"
From: Torsten Curdt <tcurdt@dff.st>
Organization: dff internet & medien
To: cocoon-users@xml.apache.org
Subject: Re: Cocoon 2 Builtin-Logicsheet Definitions
Date: Tue, 14 May 2002 22:56:09 +0200
References: <015b01c1fb87$1ac688a0$3dc2fea9@BIGBLOCKCHEVY>
In-Reply-To: <015b01c1fb87$1ac688a0$3dc2fea9@BIGBLOCKCHEVY>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200205142256.09734.tcurdt@dff.st>

On Tuesday 14 May 2002 22:37, Mark Gaither wrote:
> I'm a co-author on a book entitled "Cocoon 2 Programming: Web Publishin=
g
> 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 th=
e
> 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 My=
SQL=20
have an explicit limit clause while most other vendors (very unfortunatel=
y)=20
don't have such clauses. It goes hand-in-hand with the max-rows and skip-=
rows=20
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 wo=
rk)
"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 fin=
d 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 define=
d 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=
=20
developers wants to do it ;-)=20

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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>