On Fri, Feb 20, 2009 at 7:58 PM, nixon66 <nixon....@gmail.com> wrote:
> > tried > > Place.objects.values_list('county', flat=true).distinct() > > Now its not returning any values. > > On Feb 20, 7:49 pm, Alex Gaynor <alex.gay...@gmail.com> wrote: > > On Fri, Feb 20, 2009 at 7:46 PM, nixon66 <nixon....@gmail.com> wrote: > > > > > I'm using this in a template to get a list of items in the list. > > > > > <ul> > > > {% for item in list %} > > > <li>{{ item.var }}</li> > > > {% endfor %} > > > </ul> > > > > > The problem is that I get duplicate values when I do this. So if var1 > > > appears in my database more than once, I get it as many times as it > > > appears. I looked at using the distinct() function but could not quite > > > figure out how to get it to work the way I want. Any suggestions? > > > Thanks in advance. > > > > If you only want to print one value from the items you can do something > > like: > > > > Model.objects.values_list('field', flat=True).distinct() > > > > that will return a list of all the values in that field, but distint of > > course. > > > > Alex > > > > -- > > "I disapprove of what you say, but I will defend to the death your right > to > > say it." --Voltaire > > "The people's good is the highest law."--Cicero > > > It doesn't return models anymore, it just returns the individual items so isntead of {% for item in lst %} {{ item.var }} {% endfor %} you would do {% for item in lst %} {{ item }} {% endfor %} -- "I disapprove of what you say, but I will defend to the death your right to say it." --Voltaire "The people's good is the highest law."--Cicero --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---