Confused with django model Limit and Offset Implementation

[Swaroop Shankar V]

Hi,

Am trying to create a custom pagination for my project, but am seriously struck with the django implementation of Limit and offset. I went through the documents, instead of making me understand how it works, i ended up more confused. So suppose I have a page limit of 3 records per page and if i want to load the second set of records how should the following statement be?

Data = NewsFeedStory.objects.order_by('-updated_on')[?:?]

and similarly if i want to load the 3rd set with same page limit, how should the same statement be? I played with the django shell to figure out how this works but am still confused. Please help.

Thanks and Regards,

Swaroop Shankar V

[Daniel Roseman]

I'm not sure why this should confuse you. You seem to have correctly understood the syntax. 

This is just normal Python slicing, which Django transforms into LIMIT and  OFFSET. So, remembering that Python slicing is 0-based and the lower bound is inclusive but the upper is exclusive, the first page is [:3], the second page is [3:6], the third is [6:9], etc.

Note, however, that if you're doing pagination, you should really be using the built-in Paginator class [1], which calculates all this for you given a page number, rather than doing it yourself.

 [1]: https://docs.djangoproject.com/en/1.3/topics/pagination/

--

DR.

[Leandro Ostera Villalva]

AFAIK it is [offset:page]

Swaroop Shankar V

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django...@googlegroups.com.
To unsubscribe from this group, send email to django-users...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

--

Regards,

Leandro Ostera,

BLOG - Check what I'm doing now
EMAIL - Write me an email
SHOWCASE - Check my latest projects

[Swaroop Shankar V]

got it working thanks anyway :)

Thanks and Regards,
Swaroop Shankar V