Re: [Modeling-users] right-hand side of IN operator must be constant

[Sebastien B. <sbi...@us...>]

        Hi,

  This is indeed a bug in the generation of the SQL statement --and a
  quick check confirms that this affects every adaptors, not only
  SQLite. I'm gonna look at that.

-- S=E9bastien.

Mario Ruggier <ma...@ru...> wrote:
> Hello!
>=20
> I am attempting to use the tempting IN operator, however, it doesn't like=
 me
> doing that ;)
> The field I am using it on is a nothing-special string attribute:
>=20
> GeneralAdaptorException: Couldn't evaluate expression SELECT  COUNT(*)  F=
ROM
> SomeTable t0 WHERE ((t0.CREATEDATE > '2003-11-22 09:29:15.65' AND t0.ACTI=
ON IN
> (one, two, three, four)) AND t0.USERNAME =3D 'john'). Reason:
> _sqlite.DatabaseError:right-hand side of IN operator must be constant
>=20
> The qualifier that I pass to fetchCount() is:
>=20
> createdate>"2003-11-22 10:44:53.25" AND action IN ["one","two","three","f=
our"]
> AND username=3D=3D"john"
>=20
> Am I misusing this, or is this a problem with the IN operator?
>=20
> Cheers, mario