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

[Mario R. <ma...@ru...>]

Thanks S=E9bastien, that fixes the problem.

Running the tests after applying the patch I get the little
error below. Not sure if this is coming form this patch or not,
but must be a small typo introduced recently.

Cheers, mario

% python run.py
Traceback (most recent call last):
   File "run.py", line 42, in ?
     import test_PyModel
   File "./test_PyModel.py", line 34, in ?
     from Modeling.PyModel import *
   File "<string>", line 528
     <<<<<<< PyModel.py
     ^
IndentationError: expected an indented block


>   Okay, please see ticket #847212 and the patch provided there:
> https://sourceforge.net/tracker/=20
> index.php?func=3Ddetail&aid=3D847212&group_id=3D58935&atid=3D489335
>
>   Thanks for reporting, hopefully this should fix the problem (and =20
> fixes
>   the very same problem for date, BTW).
>
> -- S=E9bastien.
>
> Mario Ruggier <ma...@ru...> wrote:
>> Hello!
>>
>> I am attempting to use the tempting IN operator, however, it doesn't =20=

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