On Jan 17, 12:10 pm, Nader <[EMAIL PROTECTED]> wrote:
> Hallo
>
> For a reason I had to customize the Manager class of a model:
>
> class QueueManager(models.Manager):
> def usedInputs(self, id):
> from django.db import connection
> cursor = connection.cursor()
> cursor.execute("""
> SELECT * FROM usedInput WHERE jobID=%s""" % id)
> result_list = []
> for row in cursor.fetchall():
> result_list.append(row)
> return result_list
>
> This function returns a list of tuples. The I define a view function:
>
> def inputs(request, id):
> q_list = Usedinput.objects.usedInputs(id)
> return render_to_response(
> 'usedInputs/inputs.html', {'q_list': q_list}
>
> And in a template I woud present the list elements in a table:
>
> {% if q_list %}
> <table>
> <tr>
> <td>jobID</td>
> <td>processorID</td>
> <td>datasetID</td>
> <td>filename</td>
> <td>fileVersion</td>
> </tr>
> <br />
> {% for input in q_list %}
> <tr>
> <td>{{ input[0][0] }}</td>
> <td>{{ input[0][1] }}</td>
> <td>{{ input[0][2] }}</td>
> <td>{{ input[0][3] }}</td>
> <td>{{ input[0][4] }}</td>
> </tr>
> {% endfor %}
> </table>
> {% endif %}
>
> But in template we could not present the value as "input[0][0]". Would
> somebody give me a solution of this problem?
>
Make the row-creation part of your table:
{% for input in q_list %}
<tr>{% for elem in input %}<td>{{ elem }}</td>{% endfor %}</tr>
{% endfor %}
Karen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
