[sqlalchemy] Re: Subquery error with MySQL : SQLAlchemy bug ?

2007-04-18 Thread Michael Bayer
On Apr 18, 2007, at 11:43 AM, [EMAIL PROTECTED] wrote: Hi Guys, I am trying to do this simple update query : s=select([table1.c.mo_id],and_ (table1.c.msisdn==123,table2.c.mo_id==table1.c.mo_id)) s2=table2.update(table2.c.mo_id.in_(s),values={Del:tut}) try calling s.correlate(table2)

[sqlalchemy] Re: Subquery error with MySQL : SQLAlchemy bug ?

2007-04-18 Thread Michael Bayer
On Apr 18, 2007, at 11:43 AM, [EMAIL PROTECTED] wrote: Hi Guys, I am trying to do this simple update query : s=select([table1.c.mo_id],and_ (table1.c.msisdn==123,table2.c.mo_id==table1.c.mo_id)) s2=table2.update(table2.c.mo_id.in_(s),values={Del:tut}) theres a fix in r2515 which will