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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
