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

bcurtu bcurtu at gmail.com
Fri Sep 26 12:30:50 CEST 2008


Pardon?

% instead of %s?

It doesn't work... :(

On 26 sep, 12:15, Wojtek Walczak <gmin... at bzt.bzt> wrote:
> 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