I fixed the former. I did not fix the latter. It is a known problem with the new dal and one of the few things that needs to be ironed out: it does not like select('fieldname') only select(db.table['fieldname']). Not difficult to fix anyway.
On Apr 5, 2:13 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > I get this traceback when attempting to access a reference field. > > rows = db().select(db.table.ALL) > for r in rows: > r.id > r.title > r.reference_field.name > r.reference_field.description > > Traceback (most recent call last): > File "/home/tburgess/Applications/web2py/gluon/restricted.py", line > 173, in restricted > exec ccode in environment > File > "/home/tburgess/Applications/web2py/applications/pms/views/default/index.html", > line 84, in <module> > {{=db.field[column].represent(d.B[column])}} > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2210, > in __getattr__ > self.__allocate() > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2203, > in __allocate > self._record = self._table[int(self)] > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2384, > in __getitem__ > return self._db(self.id == key).select()._first() > AttributeError: 'Rows' object has no attribute '_first' > > I get this traceback from form = SQLFORM(db.mytable) > > Traceback (most recent call last): > File "/home/tburgess/Applications/web2py/gluon/restricted.py", line > 173, in restricted > exec ccode in environment > File > "/home/tburgess/Applications/web2py/applications/pms/controllers/default.py", > line 278, in <module> > File > "/home/tburgess/Applications/web2py/applications/pms/models/plugin_compression.py", > line 28, in compress_response > d = d() > File > "/home/tburgess/Applications/web2py/applications/pms/controllers/default.py", > line 15, in index > return dict(hi='hi', form=SQLFORM(db.mytable)) > File "/home/tburgess/Applications/web2py/gluon/sqlhtml.py", line > 688, in __init__ > inp = self.widgets.multiple.widget(field, default) > File "/home/tburgess/Applications/web2py/gluon/sqlhtml.py", line > 211, in widget > return OptionsWidget.widget(field, value, **attributes) > File "/home/tburgess/Applications/web2py/gluon/sqlhtml.py", line > 187, in widget > options = requires[0].options() > File "/home/tburgess/Applications/web2py/gluon/validators.py", line > 2227, in _options > options = self.other.options() > File "/home/tburgess/Applications/web2py/gluon/validators.py", line > 385, in options > self.build_set() > File "/home/tburgess/Applications/web2py/gluon/validators.py", line > 369, in build_set > records = self.dbset.select(*self.fields, **dd) > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 3258, in select > return self._db._adapter.select(self._query,*fields,**attributes) > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 501, in select > query = self.SELECT(query,*fields, **attributes) > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 432, in SELECT > tablenames.append(f._tablename) > AttributeError: 'str' object has no attribute '_tablename' > > -Thadeus -- 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.