This
db.TableA.id_TableB.represent = lambda value: "%s" %
db.TableB[value].name
should be
db.TableA.id_TableB.represent = lambda value: (db.TableB[value] or
{}).get('name','anonymous')
On Apr 7, 1:36 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/views/default/index.html",
> line 62, in <module>
> <thead>
> File "/home/tburgess/Applications/web2py/applications/pms/models/common.py",
> line 197, in <lambda>
> db.TableA.id_TableB.represent = lambda value: "%s" % db.TableB[value].name
> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2402,
> in __getitem__
> return self._db(self.id == key).select().first()
> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 3276, in select
> return self._db._adapter.select(self._query,*fields,**attributes)
> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 507, in select
> query = self.SELECT(query,*fields, **attributes)
> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 433, in SELECT
> for field in self.db[table]:
> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2102,
> in __getitem__
> return dict.__getitem__(self, str(key))
> KeyError: 'None'
>
> -Thadeus
>
> On Mon, Apr 5, 2010 at 6:00 PM, mdipierro <[email protected]> wrote:
> > 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
> > 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.
