>data = {}
>data['ids_to_process'] = ['1','2','3','5','7','11']
>
>query = '''
> UPDATE my_table
> SET state = 'processed'
> WHERE id IN ARRAY%(ids_to_process)s
>'''
>db.execute(query, data)
>
Sorry. It should look like ...
query = '''
UPDATE my_table
SET state = 'processed'
WHERE id = ANY(ARRAY%(ids_to_process)s)
'''
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
