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

[Bruno Desthuilliers]

Wojtek Walczak a écrit :

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 '%'.

Please avoid such clueless advices and read the doc of the python db-api.

--
http://mail.python.org/mailman/listinfo/python-list