Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-dev@xml.apache.org
Reply-To: <c.watson@zen.co.uk>
From: "Christopher Watson" <c.watson@zen.co.uk>
To: <cocoon-dev@xml.apache.org>
Subject: RE: ESQL Error in Cocoon 2.0.3-branch
Date: Thu, 2 May 2002 13:40:53 +0100
Message-ID: <NBBBLCICEMCMDJHAAIFMCEMGEEAA.c.watson@zen.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: <3CD12FF5.AEA7C70B@wincor-nixdorf.com>

John,

This looks like MicroSoft Access syntax. Here's one I prepared earlier ...

SELECT [Table One].[Field One] FROM [Table One];

I haven't seen it elsewhere

Christopher
> -----Original Message-----
> From: Enke, Michael [mailto:michael.enke@wincor-nixdorf.com]
> Sent: 02 May 2002 13:24
> To: cocoon-dev@xml.apache.org
> Subject: Re: ESQL Error in Cocoon 2.0.3-branch
>
>
> The syntax [a table] I don't know and it doesn't work with postgres.
> As I know, spaces are not permitted in table-, column- etc names.
> The only one exception are column aliases: select column.table as
> "My column" from table.
>
> "Morrison, John" wrote:
> >
> > Just out of curiosity, if a column alias (or any other field for that
> > matter) has a space in it, shouldn't it be referenced:
> >
> > [a table].[some field]
> >
> > ?
> >
> > J.
> >
> > > -----Original Message-----
> > > From: Enke, Michael [mailto:michael.enke@wincor-nixdorf.com]
> > > Sent: Thursday, 2 May 2002 9:53 am
> > > To: cocoon-dev@xml.apache.org
> > > Subject: Re: ESQL Error in Cocoon 2.0.3-branch
> > >
> > >
> > > This will work as a first help. But
> > > for column aliases with spaces or capital/non-capital letters
> > > it is not possible to change " to '
> > > Another possibility is to escape every " to \"
> > > But for a clean solution please create a new bug report via bugzilla.
> > >
> > > Michael
> > >
> > > "Morrison, John" wrote:
> > > >
> > > > Best thing to do is check the java that's generated.  At a guess
> > > > it puts " around the query string.  Try changing your "s to '.
> > > >
> > > > J.
> > > >
> > > > > -----Original Message-----
> > > > > From: Dude [mailto:realdude@gmx.net]
> > > > > Sent: Wednesday, 1 May 2002 8:33 pm
> > > > > To: cocoon-dev@xml.apache.org
> > > > > Subject: ESQL Error in Cocoon 2.0.3-branch
> > > > >
> > > > >
> > > > > Hello!
> > > > >
> > > > > I moved from cocoon 2.0b1 to 2.0.3 and my esql-xsp scripts
> > > > > dont work any more. querys like this
> > > > >
> > > > > <esql:query>
> > > > >    SELECT
> > > > > "DBADMIN"."KATEGORIE"."KID","DBADMIN"."KATEGORIE"."NAME" FROM
> > > > > "DBADMIN"."KATEGORIE"
> > > > > </esql:query>
> > > > >
> > > > > worked fine with 2.0b1
> > > > >
> > > > > but 2.0.3 says
> > > > >
> > > > > ---
> > > > >
> > > > > Language Exception
> > > > >
> > > > > More precisely:
> > > > >
> > > > > org.apache.cocoon.ProcessingException: Language Exception:
> > > > > org.apache.cocoon.components.language.LanguageException:
> > > > > Error compiling swKategorie_xsp:
> > > > > Line 380, column 33: ')' expected
> > > > > Line 0, column 0:
> > > > > 1 error
> > > > >
> > > > > ---
> > > > >
> > > > > i guess the fault is the " in the SELECT statement, because
> > > > > java dont like
> > > > >
> > > > > String sql="SELECT "DBADMIN" ... ";
> > > > >
> > > > > i can only say, that this stuff works fine with 2.0b1
> > > (until 2.0.1?)
> > > > >
> > > > > Greets, Steve
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> > > > > For additional commands, email: cocoon-dev-help@xml.apache.org
> > > > >
> > > >
> > > >
> > > ==============================================================
> > > =========
> > > > Information in this email and any attachments are
> > > confidential, and may
> > > > not be copied or used by anyone other than the addressee,
> > > nor disclosed
> > > > to any third party without our permission.  There is no intention to
> > > > create any legally binding contract or other commitment
> > > through the use
> > > > of this email.
> > > >
> > > > Experian Limited (registration number 653331).
> > > > Registered office: Talbot House, Talbot Street, Nottingham NG1 5HF
> > > >
> > > >
> > > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> > > > For additional commands, email: cocoon-dev-help@xml.apache.org
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> > > For additional commands, email: cocoon-dev-help@xml.apache.org
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> > For additional commands, email: cocoon-dev-help@xml.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org
>
>


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