[sqlalchemy] how can i use bind parameters with an ilike ?

[Jonathan Vanasco]

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 )

is this a feature request ?

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.