succceeded by using "extra" specified here: http://www.djangoproject.com/documentation/db-api/#extra-select-none-where-none-params-none-tables-none
Thanks :) 2008/4/26 realfun <[EMAIL PROTECTED]>: > Thanks a lot for quick answer, I will try this solution > > 2008/4/26 Malcolm Tredinnick <[EMAIL PROTECTED]>: > > >> >> On Sat, 2008-04-26 at 10:52 +0800, realfun wrote: >> > I am writing a simple Django App, the model is like this: >> > class MyPosts(models.Model): >> > >> > content = models.TextField() >> > >> > >> > class MyPostComments(models.Model): >> > >> > mypost = models.ForeignKey(MyPosts) >> > >> > comment = models.TextField() >> > Now I need to query the top10 most-commented posts. >> > >> > After look at the online document for hours I couldn't find out a way >> > to do it. >> >> To do that directly with Django's ORM would require aggregate support, >> since you need a column that represents count(*) and some grouping. That >> support doesn't exist yet (it's a Summer of Code project). >> >> You might be able to cobble something together using extra(select=...), >> but, personally, I'd just use raw SQL to do this. When you know the >> query you want to execute, there's nothing wrong with just doing it in >> SQL. >> >> Regards, >> Malcolm >> >> -- >> Everything is _not_ based on faith... take my word for it. >> http://www.pointy-stick.com/blog/ >> >> >> >> >> > > > -- > http://www.2maomao.com/blog > -- http://www.2maomao.com/blog --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
