Hi,
Can't you escape the sequence by adding another %, so that the line becomes:
q=e.text("select * from some_table where some_field like '%%a word%%'")
Cheers,
Nick
Dennis Muhlestein wrote:
> 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
>
>
-------------------------------------------------------------------------
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
