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 12:47:17 GMT
Thanks, I knew it rang a bell.  It's also used for SQLServer for when
you use a 'reserved' word as a field or start the field name with a
number.  Thought it might have been more generic than that though - 
should have known better with it being M$.

J.

> -----Original Message-----
> From: Christopher Watson [mailto:c.watson@zen.co.uk]
> Sent: Thursday, 2 May 2002 1:41 pm
> To: cocoon-dev@xml.apache.org
> Subject: RE: ESQL Error in Cocoon 2.0.3-branch
> 
> 
> 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
> 


=======================================================================
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


Mime
View raw message