[Tutor] Building an SQL query

[Lee Harr]

>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/