cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Morrison, John" <John.Morri...@uk.experian.com>
Subject RE: ESQL Error in Cocoon 2.0.3-branch
Date Thu, 02 May 2002 08:59:53 GMT
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


Mime
View raw message