I'm trying to create a query that uses the like operand to search a field. example:
e=create_engine(..... q=e.text("select * from some_table where some_field like '%a word%'") q.execute() I get this: sqlalchemy.exceptions.SQLError: (TypeError) unindexable object .... It works without the % of course, but I'm not sure how to delimit that query so sqlalchemy doesn't break. Thoughs? Help? Thanks -Dennis ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users