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]
