Re: Drop down box in django getting populated from a database table column

On Thursday, 30 June 2011 18:51:54 UTC+1, sony wrote:

I searched the same thing on net and got many answers but some how
dint get working with any of them. Table: 1. Report :
reportType(foreign key from ReportCategory), name, description 2.
Report Category: name,description forms.py

class ReportForm_insert(forms.ModelForm):

class Meta:
    model=Report
    invent = ReportCategory.objects.all()
    print invent
    reportType_id = forms.ModelMultipleChoiceField(queryset = invent)

    fields =('name','description',)

model.py

class ReportCategory(models.Model):

name = models.CharField(max_length=20)

description =  models.CharField(max_length=20)

def __unicode__(self):
    return self.name

class Report(models.Model):

reportType = models.CharField(max_length=200)

name = models.CharField(max_length=200)

description = models.CharField(max_length=300)

def __unicode__(self):
    return self.name

I want the ReportType to be shown as a drop down box which would
contain values from the name column of the Report Category table. I am
surely going wrong big way but I am not understanding what to do... So
I am not understanding whether there is a problem with not able to
handle the foreign key or the drop down box.

It's not so much "going about it the wrong way" as "posting completely nonsensical code". You certainly didn't see anywhere "on the net" anything that told you to write logic in the Meta inner class.

You don't have a ForeignKey in your model. If you want the reportType field to be populated with elements from the ReportCategory model, you should make it a ForeignKey.

--

DR.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/pxcNfwc_oCAJ.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.