You cannot do a join in a IS_IN_DB IS_IN_DB(db((db.flockdata.flock==db.flocks.id)&(db.flockdata.house==db.houses.id)), db.flockdata.id, '%(houses.name)s')),
and the format cannot contain a "." On Sep 7, 7:33 am, Andrew Thompson <[email protected]> wrote: > db.define_table('houses', > Field('name', 'string', length=100, > requires=IS_NOT_EMPTY()), > Field('ordinal','integer')) > > db.define_table('flocks', > Field('name', 'string', length=100, > requires=IS_NOT_EMPTY()), > Field('ordinal','integer')) > > db.define_table('flockdata', > Field('flock', db.flocks, requires=IS_IN_DB(db, > db.flocks.id, '%(name)s')), > Field('house', db.houses, requires=IS_IN_DB(db, > db.houses.id, '%(name)s')), > Field('x_count', 'integer', requires=IS_NOT_EMPTY()), > Field('y_count', 'integer', requires=IS_NOT_EMPTY()), > Field('active', 'boolean', > requires=IS_NOT_EMPTY(),default=True)) > > db.define_table('dailyentry', > Field('flockdata', db.flockdata,requires=IS_IN_DB( > > db((db.flockdata.flock==db.flocks.id)&(db.flockdata.house==db.houses.id)), > db.flockdata.id, '%(houses.name)s')), > Field('date','date'), > Field('wumba', 'integer')) > > I have two tables, houses and flocks, that are both used as keys in > flockdata. Each day, users will enter information into dailyentry. They > expect to set the proper house/flock combination by choosing 'houses.name'. > > The select query below shows me a field named houses.name, but the > IS_IN_DB above will not let me use it. > > dailyentry=db((db.flockdata.flock==db.flocks.id)&(db.flockdata.house==db.dailyentry.id)).select() > > Traceback (most recent call last): > File "/var/www/web2py/gluon/restricted.py", line 186, in restricted > exec ccode in environment > File "/var/www/web2py/applications/tyc/controllers/dailyinput.py", > line 20, in <module> > File "/var/www/web2py/gluon/globals.py", line 96, in <lambda> > self._caller = lambda f: f() > File "/var/www/web2py/gluon/tools.py", line 2219, in f > return action(*a, **b) > File "/var/www/web2py/applications/tyc/controllers/dailyinput.py", > line 12, in edit > form = SQLFORM(db.dailyentry) > File "/var/www/web2py/gluon/sqlhtml.py", line 724, in __init__ > inp = self.widgets.options.widget(field, default) > File "/var/www/web2py/gluon/sqlhtml.py", line 186, in widget > options = requires[0].options() > File "/var/www/web2py/gluon/validators.py", line 422, in options > self.build_set() > File "/var/www/web2py/gluon/validators.py", line 406, in build_set > records = self.dbset.select(*self.fields, **dd) > File "/var/www/web2py/gluon/sql.py", line 3216, in select > rows = response(query) > File "/var/www/web2py/gluon/sql.py", line 3211, in response > db._execute(query) > File "/var/www/web2py/gluon/sql.py", line 947, in <lambda> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > OperationalError: no such column: flockdata.houses.name > > Am I missing something, or is IS_IN_DB being daft? > > -- > Andrew Thompsonhttp://aktzero.com/
