Tim Chase enlightened us with:
> >>> cur.execute("select * from people where last_name in (%s)" %
>       ','.join('%s' for i in xrange(len(t))),
>       t)

But since the value of 'i' isn't used at all, it can be abbreviated
to:

>>> cur.execute("select * from people where last_name in (%s)" %
        ','.join('%s' for i in t),
        t)

Sybren
-- 
Sybren Stüvel
Stüvel IT - http://www.stuvel.eu/
-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to