Area.objects.values('name','city') On Jul 31, 5:07 pm, strayhand <tobyb...@gmail.com> wrote: > I want to grab a single column in a model and use it to populate a > multi-select form field. Here's the code that I'm currently using: > > areas = forms.ModelMultipleChoiceField(queryset=Area.objects.all(), > label='Preferred Areas', help_text='Select the areas that you\'d like > to serve.') > > This code returns the entire Model. I tried using > queryset=Area.values('name') and it didn't work. How am I suppose to > grab a single column out of a model? My model and form code have been > provided below. Thanks. > > #register.forms > > from django import forms > from django.db import models > from django.forms import ModelForm > from ylbbq.areas.models import Area > > STATES = ( > ('AK', 'Alaska'), > ... > ('YT', 'Yukon'), > ) > > COUNTRIES = ( > ('USA', 'United States'), > ('Canada', 'Canada') > ) > > class RegisterForm(forms.Form): > username = forms.CharField(max_length=30) > first_name = forms.CharField(max_length=30) > last_name = forms.CharField(max_length=30) > password1 = forms.CharField(max_length=60) > password2 = forms.CharField(max_length=60) > email = forms.EmailField(help_text='Enter a valid e-mail address.') > phone = forms.CharField(max_length=12) > address = forms.CharField(max_length=70) > city = forms.CharField(max_length=50) > state_province = forms.ChoiceField(choices=STATES, label='State or > Province') > country = forms.ChoiceField(choices=COUNTRIES) > zip_code = forms.CharField(max_length=5) > birth_date = forms.DateField() > areas = forms.ModelMultipleChoiceField(queryset=Area.objects.all(), > label='Preferred Areas', help_text='Select the areas that you\'d like > to serve.') > > # areas.model > > from django.db import models > > class Area(models.Model): > name = models.CharField(max_length=40) > city = models.CharField(max_length=50) > phone = models.CharField(max_length=12) > email = models.EmailField()
-- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@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.