cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Enke, Michael" <michael.e...@wincor-nixdorf.com>
Subject Re: ESQL Error in Cocoon 2.0.3-branch
Date Thu, 02 May 2002 08:52:48 GMT
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


Mime
View raw message