HI,
pep selects all the masters.
event select all the details, but there are some masters that have no
details
In the view I have for loop for all masters(pep).
within this loop I have a loop for event
When I run I get an error that "the field description in event does
not exist"
How would this be considered as inner or outer join?
I thought I could check for non existing event records but I thought
about a GOTO
This is not a normaluse of web2py, I sould normally pick one master
and search for just the details linked to the master.
Thanks ,
Jim
=========================================================================
{{extend 'layout.html'}}
<h2>Person and Events:</h2>
<h2>
{{for person in pep:}}
[{{=A(person.last_name,_href=URL(r=request,f='person/
%s'%person.id))}}]
</h2><br/><br/>
<h1>Featured Events</h1>
<p><center><table width="80%">
{{if len(ev):}}
<tr>
{{for ev in ev:}}
<td>
<p>{{=ev.description}}</p>
</td>
</tr>
{{pass}}
{{else:}}
<h2> no events</h2>
{{pass}}
{{pass}}
</table></center></p><br/><br/>
===========================================================
pep=db(db.person.id> 0).select(db.person.ALL,orderby=db.person.id)
form=SQLFORM(db.events,fields=['end_date','description'])
event=db(db.events.person==db.person.id).select
(db.events.ALL,orderby=db.events.person)
On Oct 1, 10:30 pm, mdipierro <[email protected]> wrote:
> Sorry, I do not understand. Is this a quesiton about OUTER JOIN vs
> INNER JOIN?
>
> On Oct 1, 10:09 pm, jayvandal <[email protected]> wrote:
>
> > HI,
> > I have one(master) to many, except the many doesn't exist so ----
> > how do you get to the next one( master).
> > In the days of goto I would go back to read a master until I get a
> > master that was equal to many
> > Thanks for any advice,
> > Jim
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
