On Thu, May 21, 2009 at 5:40 PM, mdipierro <[email protected]> wrote:

>
> My guess is that you want all people with a last starting with a
> letter 'A' you can do
>
>   qy = dbhlx((dbhlx.contact.lastname.like('A%')).select()


Right - the point being, you need to think in terms of SQL forming (to fetch
your data); not in terms of Python data-slicing ;-)


>
>
> or
>   c='A'
>   qy = dbhlx((dbhlx.contact.lastname.like(c+'%')).select()
>
> you can combine multiple queries with OR.
>
> OR and like(..) do not work on GAE.
> >
>

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

Reply via email to