On Thu, 2006-07-20 at 08:35 +0200, Neilen Marais wrote: > Matthew, > > Thanks for the info. > > On Thu, 20 Jul 2006 10:05:43 +1000, Matthew Flanagan wrote: > > >> In [73]:Image.objects.filter(tags__id=1).filter(tags__id=2) > >> Out[73]:[] > >> > > > > I think you want to use: > > > > Image.objects.filter(tags__id__in=[1,2]).distinct() > > Alas, this returns all the images with tag1 OR tag2. I'm looking for > images with tag1 AND tag2.
Here's a solution that I prepared earlier (it talks about finding all groups containing a subset of people, but it's the same problem): http://www.pointy-stick.com/blog/2006/06/14/custom-sql-django/ Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
