how to replace and string in a "SELECT ... IN ()"

Wojtek Walczak gminick at bzt.bzt
Fri Sep 26 06:15:33 EDT 2008


On Fri, 26 Sep 2008 02:32:50 -0700 (PDT), bcurtu wrote:

> I have a BIIIIIG problem with the next query:
>
>         cursor.execute("""
>                     SELECT titem.object_id, titem.tag_id
>                     FROM tagging_taggeditem titem
>                     WHERE titem.object_id IN (%s)
>                 """,( eid_list))
                     ^
It should rather be '%'.
HTH.

-- 
Regards,
Wojtek Walczak,
http://tosh.pl/gminick/



More information about the Python-list mailing list