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.
