abe: > I'm trying to call object_list in > > django/views/generic/list_detail.py > > with allow_empty=True > > but if I use {{object_list.count}} in a template I get the following > error: > > > (1064, "You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'count,1' at line 1") > > the generated sql looks like: > > > SELECT DISTINCT > `db_tmpcompound`.`id`,`db_tmpcompound`.`name`,`db_tmpcompound`.`mol_weight` > FROM `db_tmpcompound` > WHERE ((`db_tmpcompound`.`db_nr` < 5)) > ORDER BY `db_tmpcompound`.`db_nr` ASC LIMIT count,1
See this ticket: http://code.djangoproject.com/ticket/2351 Michael -- noris network AG - Deutschherrnstraße 15-19 - D-90429 Nürnberg - Tel +49-911-9352-0 - Fax +49-911-9352-100 http://www.noris.de - The IT-Outsourcing Company Vorstand: Ingo Kraupa (Vorsitzender), Joachim Astel, Hansjochen Klenk - Vorsitzender des Aufsichtsrats: Stefan Schnabel - AG Nürnberg HRB 17689 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---