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]
