On Jan 3, 11:58 pm, Lee Hinde <[EMAIL PROTECTED]> wrote:
> I have two models, presented below:
>
> class Winery(models.Model):
> """(Winery description)"""
> name = models.CharField(blank=False, maxlength=100,
> db_index=True)
> winery_id = models.CharField(blank=True, maxlength=100)
> corporate_name = models.CharField(blank=True, maxlength=100)
> address = models.CharField(blank=True, maxlength=100)
> city = models.CharField(blank=True, maxlength=100)
> state = models.CharField(blank=True, maxlength=10)
> zipcode = models.CharField(blank=True, maxlength=11)
>
> class Admin:
> list_display = ('name',)
> search_fields = ('name',)
> class Meta:
> ordering = ('name',)
> verbose_name_plural = "Wineries"
>
> def __str__(self):
> return self.name
>
> def __unicode__(self):
> return self.name
>
> class Wine(models.Model):
> """The Wine table"""
> class_number = models.CharField(blank=True, maxlength=100)
> wine_name = models.CharField(blank=True, maxlength=100,
> db_index=True)
> appellation = models.CharField(blank=True, maxlength=100)
> appellation_id = models.ForeignKey(Appellation,
> verbose_name="Appellation")
> vintage_date = models.CharField(blank=True, maxlength=10)
> estate_bottled = models.NullBooleanField()
> vineyard_designation = models.NullBooleanField(default=False)
> vineyard_name = models.CharField(blank=True, maxlength=100)
> varietal = models.CharField(blank=True, maxlength=100)
> varietal_id = models.ForeignKey(Varietal, verbose_name="Varietal")
> gallons_produced = models.PositiveIntegerField(blank=True,
> null=True)
> residual_sugar = models.DecimalField(max_digits=2,
> decimal_places=2)
> retail_price = models.DecimalField(max_digits=5, decimal_places=2)
> bottle_size = models.CharField(blank=True, maxlength=100)
> winery_id = models.ForeignKey(Winery, verbose_name="Winery")
>
> class Meta:
> ordering = ('winery_id','appellation_id','class_name')
>
> class Admin:
> ordering = ('winery_id','appellation_id','class_name')
> list_display =
> ('winery_id','wine_name','class_name','vintage_date')
> list_filter = ("award_medal",)
> search_fields = ('^winery_id__name',)
>
> def __unicode__(self):
> return self.wine_name
>
> In Admin, no data is shown when I list Wines. If I remove the
> "winery_id" reference in Wine's list_display, I get a complaint about
> the Meta classes' ordering line. ((1054, "Unknown column
> 'winecomp_winery.name' in 'order clause'"))
>
> If I comment out the Meta class (and remove the winery_id field), I
> get a list. But without the Winery field.
>
> If I comment out the Meta class and leave in the winery_id field, I
> get a list, but with no data.
>
> Django version 0.97-pre-SVN-unknown, using settings
> 'winesite.settings'
>
> I started playing around with this app as a learning tool last summer,
> it's evolved and I picked it up again as I gave myself the Django book
> as a Christmas present. It seems like this was working before. But it
> was several months ago and I'm old and foggy.
>
> The book says that the __str()__ of the related object is used if a
> foreign key is used in a list_display. When I came back to the
> project, it seemed like in some situations (that I can't recall right
> now) __unicode()__ was preferred. That's why I have both.
>
> Any guidance would be appreciated. I've googled the group and the
> internet without much recent commentary on this, so I'm hoping there's
> a typo someone will see.
I got some help on #django today that helped with this. Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
