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:[EMAIL PROTECTED]] > Sent: Thursday, 2 May 2002 1:41 pm > To: [EMAIL PROTECTED] > 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:[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] > ======================================================================= 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]
