Alex Gaynor wrote: > > > On Tue, Jul 7, 2009 at 12:16 AM, Magnus Valle <li...@negativehalf.com > <mailto:li...@negativehalf.com>> wrote: > > > I have a CharField model with nested choices, like this one: > > MEDIA_CHOICES = ( > ('Audio', ( > ('vinyl', 'Vinyl'), > ('cd', 'CD'), > ) > ), > ('Video', ( > ('vhs', 'VHS Tape'), > ('dvd', 'DVD'), > ) > ), > ('unknown', 'Unknown'), > ) > > In my view I have statements like > > Item.objects.filter(media='cd') > > > to retrieve the objects. But what should I do if I want to get all > 'Audio' objects, ie. both 'vinyl' and 'cd'? > > Thanks, -0.5 > > > > > Use OR queries to get ones that are either vinyl OR cd. > http://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lookups-with-q-objects > > 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 have no idea how useful that is!! I've had major problems with non-trivial database look-up with Django in the past!
Thank you very much! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
