On Tue, 2013-01-29 at 10:08:28 -0800, Jonathan Vanasco wrote: > i need to search something like this: > > select name from users where name ilike '%jonathan%'; > > i know i could do this: > > dbSession.query( models.User )\ > .filter( models.User.name.ilike( """%%%s%%""" % 'jonathan' ) > > but the name is coming from the web, so i want treat it with a bind, > like this... > > dbSession.query( models.User )\ > .filter( models.User.name.ilike( """%:name%""" ) > .params( name = 'jonathan' ) > > anyone know if something this is possible ? ( the above does not > work )
How about using dbSession.query(models.User).filter(models.User.contains(name)) -- Audrius Kažukauskas http://neutrino.lt/
pgpoIzBxhu_El.pgp
Description: PGP signature
