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.