Dear colleagues,
please help, it seem that count method used in template does not work for
collections of records populated in views via direct "raw" query.
*Example in view:*
recordset = ASSETS.objects.raw('select s.col1, s.col2 from table s where
s.col3 = to_char(%s)', [xxx])
*Example in template:*
{% with total=recordset.count %}
<p class="float-right">{{ total|default:"0" }} record{{ total|pluralize }}
found</p>
{% endwith %}
Select returns approx. 20 rows, they are successfully populated into
"recordset", they are iterable, can be accessed and displayed with no
problem.
However "recordset.count" returns nothing.
In case that the recordset is populated in standard way through
ASSETS.object.filter, the "count" method works fine. Unfortunately,
"objets.filter" can not be used in this case.
Thanks for help.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/e9f583aa-0cde-443c-88b4-b381cbf67d69%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
