It seems to me correct except for the view, if you want a table not use :
Controller :
table = crud.select(db.data)
return dict(table=table)
View :
{{=table}}
You can also make your select constraint in the controller :
query = (db.data.FIELD == SOMETHING)
table = crud.select(db.data, query=query)
http://www.web2py.com/book/default/chapter/07?search=crud.select#CRUD
Richard
On Mon, Sep 12, 2011 at 4:27 PM, Chris Rowson
<[email protected]> wrote:
> I have two tables:
> -----------------------------------------
> db.define_table('providers',
> Field('name'),
> Field('email'),
> Field('tel')
>
> db.define_table('data',
> Field('dataowner', db.auth_user, default=auth.user_id,
> writable=False, readable=False), #this points at the auth user
> Field('provider', db.providers),
> Field('speed', 'integer')
>
> db.data.provider.requires=IS_IN_DB(db, 'providers.id','providers.name')
> ---------------------------------------------
>
> My controller has this code
>
> def map():
> response.view="map.html"
> # selects the data postcode fields from the database
> # returns an interable object
> rows=db().select(db.data.lon, db.data.lat, db.data.provider)
> return dict(rows=rows)
>
> -----------------------------------------------
>
> And my view this code
>
> {{for i,row in enumerate(rows):}}{{if not i==0:}},{{pass}}
> { lat: {{=row.lat}}, lng: {{=row.lon}}, name: "{{=row.provider.name}}" }
> {{pass}}
>
> ------------------------------------------------
> As you can see, the provider field in the data table stores the provider id.
>
> I'm confused!
>
> Although this does work I don't know why!, is it the correct way to
> reference the name field from the providers table?
>
> Thanks!
>
> Chris
>
