hi, can't figure out why raw SQL works fine, but update() is not working: 1.working raw SQL: self.session.execute("update public.my_table set status='L',updated_at=now() where my_name='%s'" % (self.my_name))
2.non working update() from Alchemy: s = aliased(MyTable) query = self.session.query(s).filter(s.my_name==self.my_name) sts = self.session.execute(query).fetchone() sts.update(values={'status':'L'}) sts.update(values={s.status:'L'}) File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 2097, in _key_fallback "Could not locate column in row for column '%s'" % key) sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column 'update'" But Column s.status exists ... appreciate any help, --vs -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.