[sqlalchemy] binding values for the in() statement

2010-04-08 Thread Tarek Ziadé
Hello, I am trying to bind a list for an in() operator in a pure SQL query : import sqlalchemy engine = create_engine('mysql://localhost/database') connection = engine.connect() connection.execute(engine.text(select * from user where email in (:emails)), emails=['ta...@ziade.org']) This

Re: [sqlalchemy] binding values for the in() statement

2010-04-08 Thread Michael Bayer
Tarek Ziadé wrote: Hello, I am trying to bind a list for an in() operator in a pure SQL query : import sqlalchemy engine = create_engine('mysql://localhost/database') connection = engine.connect() connection.execute(engine.text(select * from user where email in (:emails)),