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, Oct 16 '16 at 11:17
My apologies, question updated to include the source. It is django based. — Alan Tingey, Oct 16 '16 at 11:20
You should call `fetchall` and then `recentResultHistory` should be a list and you have no problems. — Daniel, Oct 16 '16 at 11:21
Sorry Daniel, i am using "recentResultHistory = cursor.fetchall". Is this what you meant? — Alan Tingey, Oct 16 '16 at 11:25

score 0 · Accepted Answer · edited May 23 '17 at 12:08

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 '17 at 12:08

Community

1
1

answered Oct 16 '16 at 11:38

Alan Tingey

835
11
39

Python Loop In HTML

1 Answers1