Re: Chain filters on ManyToManyField

2006-09-10 Thread cyberco
Just for the record: ANDing 2 Q-objects doesn't work either... --~--~-~--~~~---~--~~ 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

Re: Chain filters on ManyToManyField

2006-08-14 Thread Laundro
I'm working from the top of my head here (I'm at work), but wouldn't ANDing two Q's be a solution? I remember having constructed a QuerySet of two Q's &'ed together, as in qs = (Q() & Q()), and then evaluating qs. --~--~-~--~~~---~--~~ You received this message be

Re: Chain filters on ManyToManyField

2006-08-13 Thread Malcolm Tredinnick
On Sun, 2006-08-13 at 21:23 +, cyberco wrote: > Ai, really? I'm a n00b when it comes to SQL and the SQL statement of a > chained filter (as listed by connection.queries) is about 8 (!) lines > of SQL abacadabra. There's a worked example here: http://www.pointy-stick.com/blog/2006/06/14/custom

Re: Chain filters on ManyToManyField

2006-08-13 Thread cyberco
Ai, really? I'm a n00b when it comes to SQL and the SQL statement of a chained filter (as listed by connection.queries) is about 8 (!) lines of SQL abacadabra. Sure there is no other way to solve this issue? Will the bug be fixed in the next release? --~--~-~--~~~---~

Re: Chain filters on ManyToManyField

2006-08-13 Thread Malcolm Tredinnick
On Sun, 2006-08-13 at 12:31 +, cyberco wrote: > Having: > ___ > > class Pizza(models.Model): > name = models.TextField() > toppings = models.ManyToManyField(Topping) > > class Topping(models.Model): > name = models.TextField() > ___ > > ...and for instanc

Chain filters on ManyToManyField

2006-08-13 Thread cyberco
Having: ___ class Pizza(models.Model): name = models.TextField() toppings = models.ManyToManyField(Topping) class Topping(models.Model): name = models.TextField() ___ ...and for instance having toppings 'tomato' and 'cheese', how do I select all pizza's with