I am having trouble figuring out how to query the database and return
the results in a format that my template can render appropriately.
I have a model that has a ManyToMany field:

class Student()
     ...
     parents = models.ManyToManyField('parents.Parent', blank=True,
null=True)
     ...
The Parent model looks like:

class Parent()
    ...
    first_name  models.CharField(max_length=30)
    last_name  models.CharField(max_length=30)
    gender  models.CharField(max_length=1)
    ...
    def __unicode__(self):
          return u'Parent : %s %s' % (self.first_name, self.last_name)

The method in my view currently looks something like this:

def get_parents( request, template )
   id=request.GET['id']
   template_data["parents"] = Parent.objects.filter(student=id)
   return render_to_response( template, template_data,
context_instance=RequestContext(request))

The template data is returning the data in the format:
  [ <Parent: Parent: Bob Thomas>, <Parent: Parent: Mary Thomas>]

Instead, I need the template data formatted with the other fields in
my Parent model, like:
  [ <Parent: { id: 3, first_name: Bob, last_name: Thomas}>,
    <Parent: { id: 4, first_name: Mary, last_name: Thomas}> ]

The format doesn't have to be exactly like the above, but I need to
include the index, and to return some of the other fields defined in
my Parent model.
My template will look something like:
{% for parent in parents.object_list %}
<tr>
     <td>{{parent.id}}</td>
     <td>{{parent.first_name}}</td>
     <td>{{parent.last_name}}</td>
{% endfor %}

Can someone give me some ideas about how I can change my view to
return my template data in a more useable format?

-- 
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.

Reply via email to