Michael Bayer wrote:
> The basic request to get cities as strings by themselves should be
> easy enough as:
>
> select([Customer.city]).distinct().order_by(
> Customer.city).execute().fetchall()
That's exactly what I wanted - and yes, that's really easy.
> we will eventually have a database-neutral "ilike" comparator but that
> hasn't been implemented yet.
Ok, I'll use the approach with func.lower().like("a%") until then. I
noticed func.lower().startswith("a") is also possible, a bit nicer.
Thanks a lot for your quick support!
-- Chris
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
