QuoteSQL

Sybren Stuvel sybrenUSE at YOURthirdtower.com.imagination
Tue Sep 26 10:25:13 EDT 2006


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/



More information about the Python-list mailing list