On Fri, 2006-05-12 at 01:33 -0700, Rob Hudson wrote:
> I think I'm making this harder than it should be. Could someone help
> me out here please? The gist is that I'm trying to display a list of
> events like the following. I'm getting the error "'offset' is not
> allowed without 'limit'" which doesn't seem right. I'm thinking
> someone will spot a much simpler way to accomplish this that I'm not
> seeing being new to Django. Thanks in advance...
I suspect we might be seeing this sort of question a bit now. You have a
line in your code that says
evts = Event.objects.all().order_by('date_from')
At this point, evts is a QuerySet. Which means it is an object that
*can* be evaluated to produce you results. In particular, it provides an
iterator interface so you can loop over your results, etc.
Now, slicing on QuerySets is used to provide SQL's offset and limit
functionality. So evts[1:], which you have later on in the code
translates (approximately) to SELECT ... FROM ... WHERE ... OFFSET 1. On
the other hand, something like evts[:5], translates to
SELECT...FROM...WHERE...LIMIT 5 and evts[1:5] would give you both limit
and offset.
Django's implementation lets you use limit on its own (the evts[:5]
form), or offset + limit together (evts[1:5]), but not offset on its
own. So, evts[1:] is what's causing your error.
A couple of ways around this:
(1) For a small set of results, you can explicitly convert your QuerySet
to a list
evts = list(evts)
or even
evts = list(evts)[1:]
in your specific case.
This is not a good idea is evts contained lots and lots of result rows,
since it reads everything into memory at once. But it is reasonable if
you have a couple of dozen results, say.
(2) Manually skip the first item when iterating over the evts list.So
instead of
evts = evts[1:]
you can write
results = iter(evts)
results.next() # skip the first item
for e in results: # iterate over the rest.
....
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
-~----------~----~----~----~------~----~------~--~---
