[sqlalchemy] filter seams not to work with 0.8.0

Hi list, I have problems when upgrading to SQLAlchemy 0.8.0. I have code like this: audit_q = self.session.query(AuditTable).filter(AuditTable.serial.like('something')).order_by(order_dir) which was running great with mysql on sqlalchemy 0.7.4 With 0.8.0 it seams that I never get results

Re: [sqlalchemy] filter seams not to work with 0.8.0

Am 20.03.2013 15:11, schrieb Cornelius Kölbel: Hi list, I have problems when upgrading to SQLAlchemy 0.8.0. I have code like this: audit_q = self.session.query(AuditTable).filter(AuditTable.serial.like('something')).order_by(order_dir) which was running great with mysql on

Re: [sqlalchemy] Placeholder values

Hello. I think you want this: http://docs.sqlalchemy.org/en/rel_0_7/core/expression_api.html#sqlalchemy.sql.expression.literal_column Basic usage example: from sqlalchemy.sql.expression import literal_column # Connect... print Session.query(literal_column('42')) # prints: 'SELECT

RE: [sqlalchemy] Placeholder values

Thanks! Exactly what I needed. -Original Message- From: Ladislav Lenart [mailto:lenart...@volny.cz] Sent: Wednesday, March 20, 2013 8:01 PM To: sqlalchemy@googlegroups.com Cc: Alexey Vihorev Subject: Re: [sqlalchemy] Placeholder values Hello. I think you want this: