On Mon, 2007-10-08 at 07:19 +0000, Michael wrote: [...] > The above index view retrieves all the events for the 5 most recent > days and orders them how I'd like. > > Essentially, my goal is to be able to provide previous and next links > such that older/newer events can be viewed as well. From an SQL > perspective, to obtain the data for each subsequent/previous page, I > would only need to apply an offset to the inner query to accomplish > this, but I don't know how to make that idea fit nicely in the world > of Django.
If you've arrived at the point of writing custom SQL like this, then it's likely you'll have to do things like pagination in the same fashion. Django is intentionally not designed to supply a complete wrapper around SQL because we already have SQL for that, so once you move beyond what Django does wrap, don't be afraid to stay in SQL. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---