Django Displaying Data from database

Question

I am using Django and I am trying to making a template tag to display the data from my database (sqlite3). So far this is my models.py

class Answer(models.Model):
    subject = models.ForeignKey(Subject, help_text = u'The user who supplied this answer')
    question = models.ForeignKey(Question, help_text = u"The question that this is an answer to")
    runid = models.CharField(u'RunID', help_text = u"The RunID (ie. year)", max_length=32)
    answer = models.TextField()

    def __unicode__(self):
        return "Answer(%s: %s, %s)" % (self.question.number, self.subject.surname, self.subject.givenname)

and here is my view.py

def answer_list(request):
    answer_info = Answer.objects.all()

    answer_data = {
    "answer_detail" : answer_info
    }

print answer_data
 return render_to_response('quizzes.html'', answer_data, context_instance=RequestContext(request))

to display the information that is in the database how should my quizzes.html template look like? so far I have this

{% for answer_list in answer_detail %}
<h3>{{ answer_list.question }}</h3>
<p>{{ answer_list.answer }}
{{ answer_list.runid }}</p>
{% endfor %}

I believe there is something slightly wrong with my for loop but unsure of what?

Have you gone through the tutorial? The first argument to render_to_response is the template name, not the URL. — Burhan Khalid
– Burhan Khalid, Commented Nov 27, 2013 at 6:54

Tim Wilder · Accepted Answer · 2013-11-27 06:57:52Z

3

answers_detail in your tag is not the same as the "answer_detail" key that you pass in your context dict. There's an extra s in the tag version.

edited Nov 27, 2013 at 6:57

answered Nov 27, 2013 at 6:53

Tim Wilder

1,6471 gold badge19 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user3019469 Over a year ago

That doesnt seem to be the problem. What should the blank be in {% for ______ in answer_detail %}

Tim Wilder Over a year ago

It's an arbitrary name. You can put down whatever you like, then as long as you reference it with the same name, that won't be a problem.

user3019469 Over a year ago

That is what I thought. I dont understand why the db data is display in my template.

user3019469 Over a year ago

No I think maybe its in my URLS? my quizzes template is url(r'quizzes/$', (TemplateView.as_view(template_name="quizzes.html"))),

Tim Wilder Over a year ago

I think looking at one of the popular tutorials might be a good use of time. Try replacing that classed based view reference in your urlconf with url(r'quizzes/$', path.to.answer_list).

Collectives™ on Stack Overflow

Django Displaying Data from database

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related