Python Loop In HTML

Question

I have the following row within a table:

<TR>
    <TD style="text-align:center;width:50px">{% for z in recentResultHistory %} {{ z.0 }} {% endfor %}</TD>
    <TD style="text-align:center;width:100px"></TD>
    <TD style="text-align:center;width:50px">V</TD>
    <TD style="text-align:center;width:100px"></TD>
    <TD style="text-align:center;width:50px">{% for z in recentResultHistory %} {{ z.0 }} {% endfor %}</TD>
</TR>

when the first instance of the {% for z in recentResultHistory %} {{ z.0 }} {% endfor %} runs I get the expected result. When it runs for the second time it produces no results like it is not looping at all. Do I need to reset the loop in some way?

The variable is created in my django view.py as follows:

        cursor = connection.cursor()

        cursor.execute("""
                        select
                        team,
                        group_concat( concat(result, '-', convert(opponent USING utf8), '-', team_score, '-', opponent_score, '-', mstatus)
                                     order by fixturedate desc
                                    separator '|') as output from plain_result
                        where (select count(*)
                               from plain_result as p
                               where plain_result.team = p.team
                               and p.fixturedate>=plain_result.fixturedate) <= 5
                        group by team
                       """)

        recentResultHistory = cursor.fetchall

We can't possibly answer this without seeing the source of recentResultHistory. And is this Django, or Jinja, or what? — Daniel Roseman
– Daniel Roseman, Commented Oct 16, 2016 at 11:17
My apologies, question updated to include the source. It is django based. — Alan Tingey
– Alan Tingey, Commented Oct 16, 2016 at 11:20
You should call fetchall and then recentResultHistory should be a list and you have no problems. — Daniel
– Daniel, Commented Oct 16, 2016 at 11:21
Sorry Daniel, i am using "recentResultHistory = cursor.fetchall". Is this what you meant? — Alan Tingey
– Alan Tingey, Commented Oct 16, 2016 at 11:25

Community · Accepted Answer · 2017-05-23 12:08:43Z

0

I should be using list(cursor) rather than cursor.fetchall(). Daniel and dkasak gave me the inspiration to look and I found the following which solved my issue:

cursor.fetchall() vs list(cursor) in Python

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Oct 16, 2016 at 11:38

Alan Tingey

98115 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Python Loop In HTML

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related