Sure enough, that was it. I just didn't know what to escape the % with.
Thanks
Dennis
On 8/8/06, Nick Joyce <[EMAIL PROTECTED]> wrote:
> 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
> >
> >
>
>
--
You can see what's happening at http://muhlesteins.com
-------------------------------------------------------------------------
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
