On Fri, Apr 17, 2009 at 1:02 PM, Thierry <lamthie...@gmail.com> wrote:
>
> Can someone tell me the equivalent QuerySet for the following sql:
>
> select city_name
> from city
> where city_name not in ('Toronto', 'Richmond', 'Montreal')
>
> From the python code, I will like to store the above 3 cities in a
> list.
> >
>
City.objects.exclude(city_name__in=['Toronto', 'Richmond', 'Montreal'])
should do exactly what you want.
Alex
--
"I disapprove of what you say, but I will defend to the death your right to
say it." --Voltaire
"The people's good is the highest law."--Cicero
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
