all() is a method on a Manager instance, that returns a QuerySet
containing every row in the table, without filtering. It is used
because you can't iterate over a Manager, only over a QuerySet.
As an example, if MyModel is a model, then MyModel.objects is a
Manager. If you tried to do this in python:
for obj in MyModel.objects:
# something
You would see an exception raised. In this case, you need to iterate
over MyModel.objects.all().
A RawQuerySet, though, is already a QuerySet. You can just iterate
over it, and it will just return every row that your SQL produces.
(Actually, that's pretty much all you can do with it, there's no way
for the ORM to add any other filtering or ordering to your custom SQL)
So, instead of trying to call all() on the QuerySet, just iterate over
it -- rather than
{% for obj in my_raw_query_set.all %}
just do
{% for obj in my_raw_query_set %}
On Thu, Feb 10, 2011 at 7:28 AM, hank23 <hversem...@stchas.edu> wrote:
> I'm trying to use raw SQL to retrieve the information that I want to
> display in a dropdown list. Here's the error that I'm getting:
>
> TemplateSyntaxError at /polls/updatepath/
> Caught AttributeError while rendering: 'RawQuerySet' object has no
> attribute 'all'
>
> I'm not sure what this is trying to tell me. I used the same SQL
> syntax that is shown in the documentation at:
>
> http://docs.djangoproject.com/en/dev/topics/db/sql/
>
> Can somebody explain this to me? thanks.
>
> --
> 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
> django-users+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
Regards,
Ian Clelland
<clell...@gmail.com>
--
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
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
