ok, i solved this way:
records=db(db.names.surname.like('%'+form.vars.surname+'%')).select()
Paolo
On 19 Dic, 11:48, pmate <pmateh...@gmail.com> wrote:
> This istruction doesn't work:
> records=db(db.names.surname.like('%(form.vars.surname')).select()
>
> but why?
> I would want to select all the records in db.names whose surname
> begins with the content of form.vars.surname.
> E.g.
> form.vars.surname='cli'
> result:
> 'clinton'
> 'clio'
> 'clippers'
>
> better, my desire would be to filter the records of db.names that
> "contain" the string in form.vars.surname.
> For "cli" it would be:
> 'clio'
> 'freeclimbing'
> etc.
>
> but how?
>
> Paolo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
