try now On Apr 5, 2:30 pm, Thadeus Burgess <[email protected]> wrote: > Now I get this for reference field > > 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.table[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() > 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 512, in select > return self.parse(rows,self._colnames) > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 707, in parse > colset[fieldname] = rid = Reference(value) > TypeError: int() argument must be a string or a number, not 'NoneType' > > -Thadeus > > On Mon, Apr 5, 2010 at 2:20 PM, mdipierro <[email protected]> wrote: > > 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 <[email protected]> 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 [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/web2py?hl=en.
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
