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

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

  Okay, please see ticket #847212 and the patch provided there:
https://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D847212&group_=
id=3D58935&atid=3D489335

  Thanks for reporting, hopefully this should fix the problem (and fixes
  the very same problem for date, BTW).

-- 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