I think the problems is that poll doesn't have a foreign key to
choice, it's the other way around. Try this:
{{poll_choices = db(db.choice.poll==poll.id).select()}}
{{ for choice in poll_choices: }}
<li>{{=choice.choice }} -- {{=choice.votes }} vote{{if
choice.votes!=1:}}s{{pass}}</li>
{{ pass }
On Mar 3, 11:51 pm, mdmcginn <michael.d.mcgin...@gmail.com> wrote:
> db.define_table('poll',
> Field('question',length=200),
>
> Field('pub_date','datetime',default=request.now,writable=False))
>
> db.define_table('choice',
> Field('poll',db.poll),
> Field('choice',length=200),
> Field('votes','integer',default=0))
>
> db.define_table('recorded_votes',
> Field('poll',db.poll),
> Field('voter',db.auth_user))
>
> On Mar 1, 9:37 pm, "mr.freeze" <nat...@freezable.com> wrote:
>
> > Can we see your model?
>
> > On Mar 1, 9:05 pm, mdmcginn <michael.d.mcgin...@gmail.com> wrote:
>
> > > From index.html:
> > > Latest Polls
> > > Answer the question [vote] [results]
>
> > > When I click on [results], I'm sent
> > > tohttp://localhost:8080/Polls/default/results/67
>
> > > ERROR 2010-03-02 02:54:08,609 restricted.py:53] In FILE: /home/
> > > michael/mycode/google_appengine/web2py/applications/Polls/views/
> > > default/results.html
>
> > > Traceback (most recent call last):
> > > File "/home/michael/mycode/web2py/gluon/restricted.py", line 173, in
> > > restricted
> > > exec ccode in environment
> > > File "/home/michael/mycode/google_appengine/web2py/applications/
> > > Polls/views/default/results.html", line 64, in <module>
> > > File "/home/michael/mycode/web2py/gluon/sql.py", line 3041, in
> > > select
> > > query = self._select(*fields, **attributes)
> > > File "/home/michael/mycode/web2py/gluon/sql.py", line 2932, in
> > > _select
> > > raise SyntaxError, 'Set: no tables selected'
> > > SyntaxError: Set: no tables selected
>
> > > INFO 2010-03-02 02:54:08,610 gaehandler.py:55] **** Request:
> > > 286.06ms/50.00ms (real time/cpu time)
> > > INFO 2010-03-02 02:54:08,618 dev_appserver.py:3246] "GET /Polls/
> > > default/results/67 HTTP/1.1" 500 -
>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@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.
