django for loop in a .html template page (newbie)

Question

The thing I really hate when learning a new language / framework is how ignorant I feel when I get stuck on a seemingly easy to solve issue.

I have a django for loop inside a html page but for some reason it is not working. I have missed something and cannot fix the issue on my own, so I turn to StackOverflow to help me.

This is my model I am running my query on models.py:

class RIAchievement(models.Model): riAchievementID = models.AutoField(primary_key=True, db_column="RIAchievementID") userLanguageVersionID = models.ForeignKey(UserLanguageVersion, db_column="UserLanguageVersionID") typeAchievementID = models.ForeignKey(TypeAchievement, db_column="TypeAchievementID") riAchievementTypeUserDescription = models.CharField(max_length=255, blank=True, null=True, db_column="RIAchievementTypeUserDescription") riAchievementDescription = models.TextField(max_length=2000, db_column="RIAchievementDescription") auth_user_id = models.ForeignKey(auth_user, db_column="auth_user_id") class Meta: db_table="RIAchievement"

This is where my models.py file is located in my project: GlobalXpy\app_data\models.py

This is the code within my views.py file:

from django.shortcuts import render_to_response from GlobalXpy.app_data.models import RIAchievement def index(request): ri_achievement = RIAchievement.objects.all() get_template = loader.get_template('ri_achievement.html') return render_to_response(get_template)

This is the for loop that is inside my template file (ri_achievement.html):

{% for e in ri_achievement %} <td> Preview Edit Duplicate Delete </td> <td> FlagPath </td> <td> AchievementType / RIAchievementTypeUserDescription </td> <td> {{ e.riAchievementDescription }} </td> {% endfor %}

Any assistance would be appreciated.

Please clarify in what way it is not working. Is it that you navigate to the page, but then you see different output from what you expected? — Andrew Gorcester
– Andrew Gorcester, Commented Apr 26, 2012 at 1:45
Where the for loop should display the output, no data is displayed. The for loop is not being undertaken. — user1261774
– user1261774, Commented Apr 26, 2012 at 2:18
First print the ri_achievement in template before for loop. Check it contains data or not? — Ahsan
– Ahsan, Commented Apr 26, 2012 at 6:13
to print the ri_achievement, do I simply write: <td> {{ ri_achievement }} </td> if so, this prints / displays nothing. — user1261774
– user1261774, Commented Apr 26, 2012 at 7:01

Burhan Khalid · Accepted Answer · 2012-04-26 08:14:49Z

16

from django.shortcuts import render from GlobalXpy.app_data.models import RIAchievement def index(request): ri_achievement = RIAchievement.objects.all() return render(request, 'ri_achievement.html',{'ri_achievement': ri_achievement})

In your template:

{% if ri_achievement %} There are {{ ri_achievement|length }} records: {% for e in ri_achievement %} <td> Preview Edit Duplicate Delete </td> <td> FlagPath </td> <td> AchievementType / RIAchievementTypeUserDescription </td> <td> {{ e.riAchievementDescription }} </td> {% endfor %} {% else %} There are no records in the system {% endif %}

answered Apr 26, 2012 at 8:14

Burhan Khalid

175k20 gold badges254 silver badges291 bronze badges

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

4 Comments

user1261774 Over a year ago

burhan, thanks for the advice. I get the message that there are no records in the system (even though there are 10 records that should be displayed). What should I check to confirm that the code is calling the module / database correctly?

Burhan Khalid Over a year ago

If you are getting "There are no records in the system", then the code is working correctly. Start a django shell manage.py shell, then from GlobalXpy.app_data.models import RIAchievement followed by RIAchievement.objects.all().count() - what does that print?

user1261774 Over a year ago

That prints 10 - the number of records in the database.

user1261774 Over a year ago

Burhan, thanks for the solution. This did not immediately work for me. So I deleted my project and database and installed a fresh installation of my django project & database / models file, which then worked. I did not find the issue that caused the problem.

Ignacio Vazquez-Abrams · Accepted Answer · 2012-04-26 01:47:13Z

2

You forgot to pass the variable.

return render_to_response(get_template, {'ri_achievement': ri_achievement})

answered Apr 26, 2012 at 1:47

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

1 Comment

user1261774 Over a year ago

I tried your suggestion, but the for loop does not execute (no data is displayed).

Collectives™ on Stack Overflow

django for loop in a .html template page (newbie)

2 Answers 2

4 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Linked

Related