Re: [Sqlalchemy-users] UPDATE with subselects in WHERE

oh wacky, total bug.  just fixed it in rev 1348.On Apr 28, 2006, at 2:44 AM, Dale Sedivec wrote:users = Table("users", engine,               Column("id", Integer, primary_key=True),               Column("name", String, unique=True, nullable=False)) users.create() passwords = Table("passwords", eng

[Sqlalchemy-users] UPDATE with subselects in WHERE

Are you supposed to be able to use a sub-select in the WHERE clause of an UPDATE through SQLAlchemy? It generated this SQL for me: UPDATE passwords SET password=? WHERE passwords.user_id = SELECT users.id FROM users WHERE users.name = ? Note the lack of parenthesis around the