Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 50837 invoked by uid 500); 25 Oct 2001 15:15:06 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 50820 invoked from network); 25 Oct 2001 15:15:05 -0000 X-Envelope-Sender-Is: Christian.Schroeter@nbg.sbs.de (at relayer lizzard.sbs.de) Message-Id: <200110251514.f9PFEVY03357@mail.fth.sbs.de> From: Schroeter Christian To: cocoon-users@xml.apache.org Content-Type: text/plain; charset="iso-8859-1" Subject: SQL-Statment with two (or more) "where" statments Date: Thu, 25 Oct 2001 17:12:00 +0200 X-Mailer: KMail [version 1.3.1] MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Hi, i use cocoon1.8.2. Now i have a little problem: i want to query my db like this: ... ... SELECT a.name FROM a, b WHERE b.fk2 =3D a.pk AND=09 b.fk1 =3D =20 ... But i get the errormessage: Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 = =3D a.pk=20 AND b.fk1 =3D ? When i only use one where statment it works, but with 2 it wount What must i change ? cu Christian --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: