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 12:24:21 GMT
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


Mime
View raw message