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 -~----------~----~----~----~------~----~------~--~---