Thx. DR.
Duh. I had the foreignkey in an earlier test and then took it out
again. Interesting that no error raised.
The other thing is that the template needed to call for the related
field thus:
<td>{{ obj.fname }} {{ obj.sname }} :
{{ obj.organisation.organisation }}</td> (seems logical now)
With these 2 changes it works fine.
BTW. The .select_related() in the above is a red herring - not needed
for this purpose but I will doubtless learn its proper uses.
As to the tutorial I did read it. Will look again to see why I missed
that template syntax detail.
I understand why the template process is silent in relation to non-
existent data fields. However, with debug on this might not be the
ideal policy.
Paul
On 24 June, 18:44, Daniel Roseman <dan...@roseman.org.uk> wrote:
> On Jun 24, 6:26 pm, paultanner <p...@virtual-techno.com> wrote:
>
>
>
>
>
> > As you can see from this I am just learning django.
> > I am trying to list contacts and their related organisations. This
> > does list the contact names.
> > No errors are raised but fields from Organisations do not show with
> > this view and template.
> > I guess I need to be more explicit in referncing the related fields
> > but have not found out how, despite looking through tutorials.
> > Any help appreciated. Paul
>
> > models.py
>
> > from django.db import models
>
> > class Contact(models.Model):
> > fname = models.CharField(max_length=40)
> > sname = models.CharField(max_length=40)
> > email = models.CharField(max_length=60)
> > dir_tel = models.CharField(max_length=25,blank=True)
> > mobile = models.CharField(max_length=25,blank=True)
> > blog = models.URLField(max_length=80,blank=True)
> > linkedin = models.CharField(max_length=40,blank=True)
> > def __str__(self):
> > return '%s %s' %(self.fname,self.sname)
>
> > class Organisation(models.Model):
> > organisation = models.CharField(max_length=60)
> > addr1 = models.CharField(max_length=40,blank=True)
> > addr2 = models.CharField(max_length=40,blank=True)
> > city = models.CharField(max_length=40,blank=True)
> > county = models.CharField(max_length=40,blank=True)
> > pcode = models.CharField(max_length=12,blank=True)
> > def __str__(self):
> > return '%s' %(self.organisation)
>
> > views.py
>
> > from models import Contact
>
> > def contact_list(request):
> > # where: .filter(fn="value")
> > contact_list=list(Contact.objects.all().select_related())
> > return render_to_response('contact_list.html',{
> > 'contact_list': contact_list,
> > })
>
> > contact_list.html
>
> > {% block content %}
> > <table border=1>
> > {% for obj in contact_list %}
> > <tr>
> > <td>{{ obj.fname }} {{ obj.sname }} : {{ obj.organisation }}</td>
> > </tr>
> > {% endfor %}
> > </table>
> > {% endblock %}
>
> The models don't seem to be related in any way. You need a ForeignKey,
> a OneToOneField or a ManyToManyField from one to the other to identify
> which organisation(s) are related to which contact(s).
>
> The tutorial shows you how to do this with Polls and Choices, you
> should be able to extrapolate that for your use case.
> --
> DR.- 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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
