On Thu, Apr 3, 2008 at 12:05 AM, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:
> > In your database ( not in the model ) rename the field 'category in > table MdlCourse to category_id and it should fix the problem... > normally a ForeignKey field name in the database is ClassName_id > Or, if you do not want to change your database column name, you can tell Django what it is by passing db_column='category' as an argument on the ForeignKey definition for category. Note the to_field argument is not needed here, by default the to_field is assumed to be the target model's primary key, and that is what you are using. Karen > On Apr 2, 6:12 pm, mthorley <[EMAIL PROTECTED]> wrote: > > Greetings, I used inspectdb to create my models and then tried editing > > the generated models in order to define the ForeignKey relationships, > > and I'm getting an error. > > > > Here's what I have. Note: I commented out the original category field > > and tried adding my own ForeignKey > > > > class MdlCourseCategories(models.Model): > > id = models.IntegerField(primary_key=True) > > name = models.CharField(max_length=765) > > description = models.TextField(blank=True) > > parent = models.IntegerField() > > > > class Meta: > > db_table = u'mdl_course_categories' > > > > class MdlCourse(models.Model): > > id = models.IntegerField(primary_key=True) > > #category = models.IntegerField() > > category = models.ForeignKey(MdlCourseCategories, to_field='id') > > sortorder = models.IntegerField() > > password = models.CharField(max_length=150) > > fullname = models.CharField(max_length=762) > > shortname = models.CharField(max_length=300) > > > > class Meta: > > db_table = u'mdl_course' > > > > Using these models I do the following in the manage.py shell > > > > >>> from cca.moodle.models import * > > >>> cs = MdlCourse.objects.all() > > >>> cs > > > > OperationalError: (1054, "Unknown column 'mdl_course.category_id' in > > 'field list'") > > > > to_field doesn't work quite like I expected. Does anyone know a way to > > make models.ForeignKey to at a specific table.column? > > > > Humblest Thanks and Kind Regards > > -- > > matthew > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
