On Jan 25, 12:42 pm, Chris <[EMAIL PROTECTED]> wrote:
> Thanks for reply but that is not what I am looking to do. my [EMAIL
> PROTECTED] table
> is NOT the categories table.
Well, as I said in my earlier post, you still haven't posted your
model code. It would help people understand better what you are trying
to do.
> In django, when it generates your models,
> it automatically generates your M2M table reference. so I have a table
> called blog that has a m2m relation with categories.
> (blog-->M2M-->categories) Right! Ok so using distinct on the category table
> would
>
> NOT work since they would already be distinct. The table that I need
> to grab results from is the M2M table NOT categories. Make sense?
Not really.
You said previously that you needed to count the number of blogs for a
given category ('politics'). The query I mentioned originally, does
that. Incidentally, the distinct() in my query is on the Blog model
and not on the Category model.
You don't need to grab results directly from the automatically
generated M2M table to get the count you are interested in. You could,
of course, fetch results directly from the M2M table using custom sql
but it's not necessary unless you want to do something other than what
you say you want to do :) In that case, please consider posting your
model.
Cheers,
-Rajesh
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
