On Oct 3, 2007, at 2:46 PM, Paul Kippes wrote:
> > Is there some other way I can execute a query using a list as a > bound parameter? > > res = db.db_con.text('SELECT module_extra_key_name FROM > module_extra_keys > WHERE module_id IN :module_ids').execute({'module_ids': [1,2]}) > > The above is giving me an "You cannot execute SELECT statements in > executemany()" error. > > This is while I'm running 0.3.8. its not really possible in the way you describe since the IN clause requires explicit bind parameters spelled out in a list, i.e. IN (?, ?, ?, ?). using SQL expression constructs will generate the bind params for you, i.e. select([sometable.c.extra_key_name], sometable.module_id.in_(1, 2)).execute() --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---