I was trying to do the following: for n in g[:]: query += ' | ' if bool(query) else '' query += "(db.contacts.membership.like('%" + n + "%'))" rows=db(query).select(db.contacts.number)
but couldn't get it to work so I resorted to executing the query using SQLexecute instead: for n in g[:]: query += ' OR ' if bool(query) else '' query += "membership LIKE \"%" + n + "%\"" rows=db.executesql('SELECT number FROM contacts where '+ query +';') Is this the web2py "way"? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---