*get next* = Info.objects.filter(id__gt=newsid).order_by('id')[:1]
*get last* = Info.objects.filter(id__lt=newsid).order_by('id')[:1]
2008/4/5, SlowLearner <[EMAIL PROTECTED]>:
>
>
> Hi, I am hoping there is a better solution to my problem than the one
> I have come up with, or one built in to the django models.
>
> I would like to include "get next" and "get last" buttons on my view.
>
> The catch is that I want to do get next, get last on an integer field
> (which is not a primary key but is unique, if that make a difference).
>
> Searching in the group and googling the internet in general turns up a
> few things but these are date based or quite old posts suggesting
> creating managers etc.
>
> My current solution is a brute force cycle over all the objects until
> I find the object wanted, the previous and the next which is not ideal
> but works.
>
> I am currently using 0.96 but I am intending to download trunk in the
> not too distant future as there is a templatetag application I want to
> use which does not work under 0.96.
>
> Thanks in advance.
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
