Hi Rajesh, Yes that worked, thanks for your help.
Regards, Eamon On Feb 1, 7:04 pm, Rajesh Dhawan <[EMAIL PROTECTED]> wrote: > Hi, > > > I am new to django, please excuse any naivity. > > Welcome to Django :) > > > > > > > I would like to list > > child and related parent records from the scenario below. Although > > quite happily displaying ChildFile records, I can't seem to display > > any ParentFile records. > > > models.py > > class ParentFile(models.Model): > > recnum = models.AutoField(primary_key=True) > > number = models.FloatField(max_digits=12, decimal_places=0) > > date = models.DateField() > > time = models.CharField(maxlength=5) > > city = models.CharField(maxlength=40) > > country = models.CharField(maxlength=40) > > ... > > > class ChildFile(models.Model): > > docket = models.ForeignKey(ParentFile, related_name = 'number', > > unique=True) > > recnum = models.TextField(unique=True) # This field type is a > > guess. > > docket = models.FloatField(max_digits=12, decimal_places=0, > > primary_key=True) > > You've two fields called docket in this model. That's not allowed. > Rename one of them and regenerate your model. > > > > > > > name = models.CharField(maxlength=40) > > date = models.DateField() > > ... > > > views.py > > def Outstanding(request): > > fLatestRecs = ChildFile.objects.filter(name = > > 'DAN').select_related().order_by('-date') > > return render_to_response('/report.html', {'fLatestRecs': > > fLatestRecs }) > > > report.html > > ... > > {% if fLatestRecs %} > > <table border="1" cellspacing="0" cellpadding="0" > > width="100%"> > > <tr bgcolor="lightblue"> > > <td>Date</td> > > <td>Time</td> > > <td>Name</td> > > <td>City</td> > > <td>Country</td> > > </tr> > > {% for ChildFile in fLatestRecs %} > > <tr bgcolor="lightblue"> > > <td>{{ ChildFile.date }}</td> > > <td>{{ ChildFile.time }}</td> > > <td>{{ ChildFile.name }}</td> > > <td>{{ ParentFile.city }}</td> > > <td>{{ ParentFile.country }}</td> > > Change those two lines like this (assuming docket is your ForeignKey > field to ParentFile): > > <td>{{ ChildFile.docket.city }}</td> > <td>{{ ChildFile.docket.country }}</td> > > Basically, you can get to a parent object by traversing the relevant > ForeignKey field of the child object instance. You might want to read > up on the DB API documentation for more details on this. > > Also, it's a common convention to use titlecasing in class names and > not in instance names. So, in your template, I would suggest renaming > ChildFile to childfile or child_file. > > -Rajesh- Hide quoted text - > > - Show quoted text -- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---