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:[EMAIL PROTECTED]] > Sent: 02 May 2002 13:24 > To: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED]] > > > Sent: Thursday, 2 May 2002 9:53 am > > > To: [EMAIL PROTECTED] > > > 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:[EMAIL PROTECTED]] > > > > > Sent: Wednesday, 1 May 2002 8:33 pm > > > > > To: [EMAIL PROTECTED] > > > > > 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: [EMAIL PROTECTED] > > > > > For additional commands, email: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > ============================================================== > > > ========= > > > > 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: [EMAIL PROTECTED] > > > > For additional commands, email: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, email: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, email: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, email: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
