[Zope-DB] Problems with "Subselect" in SQL statment

[Federico Di Gregorio]

--=-7D/8i7Vb5RvYj5i8I/dr
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Mon, 2001-11-05 at 13:17, Florian Schuler wrote:
> Hello List,
>=20
> I have a problem using ZSQL Methods. If I do something like this:
>=20
> select * from person where id !=3D (Select userid from projektmitglieder
> where projektid=3D'20');
>=20
> Zope gives me an error !=20
> Error Type: ProgrammingError
> Error Value: ERROR: More than one tuple returned by a subselect used as
> an expression. select * from person where id !=3D (Select userid from
> projektmitglieder where projektid=3D'20');

what adapter are you using?

--=20
Federico Di Gregorio
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
INIT.D Developer                                           fog@initd.org
                      The number of the beast: vi vi vi. -- Delexa Jones

--=-7D/8i7Vb5RvYj5i8I/dr
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEABECAAYFAjvmhigACgkQvcCgrgZGjevz4wCgqm3q6q2Qr72EbjAE5I2o/eqN
CjcAn1SwcvpND2mPEaoe7B0j0jYkzr5c
=iTf0
-----END PGP SIGNATURE-----

--=-7D/8i7Vb5RvYj5i8I/dr--