Thanks for the reply. I am having some issues outputting the fields
now though.
It seems 4 objects are being returned alright but when i try and
output a value it's blank.
top_videos = {}
for i in xrange(1,6):
videos = Video.objects.filter(category=i).order_by('-
hit_count')
if videos:
top_videos[i] = videos[0]
t = loader.get_template('home/display.html')
c = RequestContext(request,{
'top_videos': top_videos
})
return HttpResponse(t.render(c))
and in my template:
{% for video in top_videos %}
{{video.title}}
{% endfor %}
Any ideas what i am doing wrong ?
On Jan 27, 5:23 pm, Gabriel Reis <gabriel...@gmail.com> wrote:
> Hi,
>
> I would do something like this:
>
> top_videos = {}
> for i in xrange(1,6):
> videos = Video.objects.filter(category=i).order_by('-hit_count')
> if videos:
> top_videos[i] = videos[0]
>
> Then, access the top videos via the top_videos dict.
>
> Cheers,
>
> Gabriel
>
> --
> Gabriel de Carvalho Nogueira Reis
> Software Developer
> +44 7907 823942
>
> On Wed, Jan 27, 2010 at 3:45 PM, grimmus <graham.col...@gmail.com> wrote:
> > Hi,
>
> > On the homepage of my site i display 1 main video and then the most
> > popular video from each of the 5 categories, which is determined by a
> > hit count.
>
> > Basically i need something like the following
>
> > tv_video = Video.objects.filter(category=1).order_by('-hit_count')
>
> > But i need an object returned that gets the most popular video (just
> > the first one) from each category (1-5)
>
> > Does someone have an idea of the most efficient way to achieve this ?
>
> > Thanks, hope i was clear.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Django users" group.
> > To post to this group, send email to django-us...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/django-users?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@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.
