Monday, December 1, 2014

Query set append

Hello 

I am very new to python and Django . I have a basic question :

1. I have three database tables : Table A , Table B and Table C
2. in my views.py i do :
  • tableB_QuerySet = models.TableB.objects.filter(table_ID = <some value>)
  • This returns 4 rows from table B 
  • Then i iterate over tableB_QuerySet 
                        for x in tableB_QuerySet
                            tableC_QuerySet = models.TableC.objects.filter(tableC_id = x.<fieldname>)
  • I load the temple : template = loader.get_template(>.html>)
  • i use context : context  = RequestContext(request,{ 'tableC_QuerySet': tableC_QuerySet,})
  • return HttpResponse(template.render(context))
3. In my html template i iterate over tableC_QuerySet and print it in a table 


problem is that in my HTML prints only the last entry of  tableC_QuerySet . How do i append all the four entries from table C so that HTML gets all the four entries rather than just the last one 

PS: I cannot change the DB

Thanks in advance 
Appreciate your help



--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/196e21b6-91f4-4121-a807-fe432ef69508%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment