From cocoon-dev-return-26418-apmail-xml-cocoon-dev-archive=xml.apache.org@xml.apache.org Thu May 02 08:47:19 2002 Return-Path: Delivered-To: apmail-xml-cocoon-dev-archive@xml.apache.org Received: (qmail 68897 invoked by uid 500); 2 May 2002 08:47:17 -0000 Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-dev@xml.apache.org Delivered-To: mailing list cocoon-dev@xml.apache.org Received: (qmail 68886 invoked from network); 2 May 2002 08:47:16 -0000 From: "Enke, Michael" To: cocoon-dev@xml.apache.org Message-ID: <3CD0FE60.5C39077D@wincor-nixdorf.com> Date: Thu, 02 May 2002 10:52:48 +0200 Organization: Wincor Nixdorf GmbH & Co. KG X-Mailer: Mozilla 4.77 [de] (X11; U; Linux 2.4.4-4GB i686) X-Accept-Language: de_DE_EURO, en_US, en_GB MIME-Version: 1.0 Subject: Re: ESQL Error in Cocoon 2.0.3-branch References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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:realdude@gmx.net] > > Sent: Wednesday, 1 May 2002 8:33 pm > > To: cocoon-dev@xml.apache.org > > 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 > > > > > > SELECT > > "DBADMIN"."KATEGORIE"."KID","DBADMIN"."KATEGORIE"."NAME" FROM > > "DBADMIN"."KATEGORIE" > > > > > > 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: cocoon-dev-unsubscribe@xml.apache.org > > For additional commands, email: cocoon-dev-help@xml.apache.org > > > > ======================================================================= > 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: cocoon-dev-unsubscribe@xml.apache.org > For additional commands, email: cocoon-dev-help@xml.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org For additional commands, email: cocoon-dev-help@xml.apache.org