uploading fix. please check it. Thanks for testing this. On Apr 5, 3:59 pm, Thadeus Burgess <[email protected]> wrote: > 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/gluon/globals.py", line 96, > in <lambda> > self._caller = lambda f: f() > File > "/home/tburgess/Applications/web2py/applications/pms/controllers/default.py", > line 76, in duplicates > orderby=db.potentials.A > 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 706, in parse > (rid._table, rid._record) = (db[referee], None) > NameError: global name 'db' is not defined > > -Thadeus > > On Mon, Apr 5, 2010 at 3:01 PM, mdipierro <[email protected]> wrote: > > 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 > > 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.
