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]
