I am trying to select a name in a table called users and display it in
a view for loop. However, I get thrown an error in the view regarding
syntax. I have tried displaying the contents of "result" and it does
contain rows. The only thing that does not work is the line below. If
I remove it, the rest of the data displays no problem. NOTE: I have
not included the other data I am grabbing from the db in the below
because it was irrelevant. I have narrowed down the problem to this
one db.select.
Here is what I have:
#######CONTROLLER:######
def test():
results=db().select(db.users.ALL)
return dict(results=results)
#######VIEW:########
<table>
{{for result in results:}}
<tr>
<td>{{=db(db.users.id == result.author).select(db.users.name)[0]}}</
td>
</tr>
{{pass}}
</table>
###### ERROR: #######
Traceback (most recent call last):
File "gluon/restricted.py", line 98, in restricted
File "/Users/rom/Documents/Computers/Projects/web2py practice/web2py/
web2py.app/Contents/Resources/applications/tripplanet/views/root/
h.html", line 78, in <module>
File "gluon/globals.py", line 84, in write
File "gluon/html.py", line 89, in xmlescape
File "gluon/sql.py", line 496, in __getattr__
File "gluon/sql.py", line 490, in __getitem__
KeyError: 'xml'
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
