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.