This works for me:
def index():
rows = db(db.events.person==db.person.id).select()
return dict(rows=rows)
{{for row in rows:}}
{{=row.events.description}} : {{=row.person.first_name}}
{{=row.person.last_name}}
{{pass}}
On Sep 28, 7:44 pm, jayvandal <[email protected]> wrote:
> I tried your suggestion.
> Here is the events table. Thanks for your help. I am at a loss
> Jim
> ====================================================================
> db.define_table('events',
> Field('person',db.person),
> Field('description',length=128),
> Field('category',db.category),
> Field('contact',db.person),
> Field('start_date',length=10,
> comment='Example ex: 1975-09-20'),
> Field('end_date',length=10,
> comment='Example ex: 1975-09-20'),
> Field('address',length=128),
> Field('city',length=128),
> Field('states',db.states),
> Field('country',length=128),
> Field('zipcode',length=9),
> Field('amount','integer',default=0.0))
> db.events.contact.requires=IS_IN_DB(db,'person.id','%(first_name)s %
> (last_name)s')
> db.events.person.requires=IS_IN_DB(db,'person.id','%(first_name)s %
> (last_name)s')
> db.events.states.requires=IS_IN_DB(db,'states.id','states.state_name')
> db.events.category.requires=IS_IN_DB
> (db,'category.id','category.category_name')
> db.events.amount.requires=IS_FLOAT_IN_RANGE(0,10000)
>
> ========================================================================
> On Sep 28, 5:17 pm, "mr.freeze" <[email protected]> wrote:
>
> > I would really need to see your model to be sure but try:
> > ev=db(db.events.person==db.person.id).select()
> > for row in ev:
> > print row.events.description, row.person.name
>
> > On Sep 28, 5:51 pm, jayvandal <[email protected]> wrote:
>
> > > I changed to your suggestion and I get an error it can't find the word
> > > 'description'
> > > No matter what I try , I can put the word in quotes and it prints out
> > > the appropiate times .
> > > When I run ipython ev=db(db.events.person==db.person.id).select
> > > ('person','description')
> > > then print ev I get the values of the description
> > > The code I have looks similar to the examples I see.
> > > Any suggestions????
> > > Thanks
> > > Jim
>
> > > On Sep 28, 12:10 pm, "mr.freeze" <[email protected]> wrote:
>
> > > > I think you need to change this:
> > > > {{for events in events:}}
> > > > ...
> > > > <td>{{=description}}</td>
>
> > > > ...to this...:
> > > > {{for event in events:}}
> > > > ...
> > > > <td>{{=event.description}}</td>
>
> > > > On Sep 28, 12:46 pm, jayvandal <[email protected]> wrote:
>
> > > > > Hi again
> > > > > I can't understand why I can't(two can't) display a field in my
> > > > > project. When I run the controller statements in ipython and I print
> > > > > the results I can see the data in the description field. Yet in my
> > > > > view code I get an error., description
> > > > > Here is the code.
> > > > > Any help is appreciated
> > > > > ======================================================
> > > > > def person_events():
> > > > > pep=db(db.person.id> 0).select(orderby=db.person.id)
> > > > > form=SQLFORM(db.events,fields=['end_date'])
> > > > > events=db(db.events.person==db.person.id).select
> > > > > ('person','description')
> > > > > return dict(pep=pep,events=events,form=form)
>
> > > > > ========================================================
> > > > > {{extend 'layout.html'}}
>
> > > > > <h2>Person and Events:</h2>
>
> > > > > {{=form}}
>
> > > > > {{for person in pep:}}
> > > > > [{{=A(person.last_name,_href=URL(r=request,f='person/
> > > > > %s'%person.id))}}]
>
> > > > > <br/><br/>
> > > > > <h1>Featured Events</h1>
> > > > > <p><center><table width="80%">
> > > > > {{if len(events):}}
>
> > > > > {{for events in events:}}
> > > > > <tr>
>
> > > > > <td>{{=description}}</td>
>
> > > > > </tr>
> > > > > {{pass}}
> > > > > {{else:}}
> > > > > <h2> no events</h2>
>
> > > > > {{pass}}
>
> > > > > {{pass}}
> > > > > </table></center></p><br/><br/>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
