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 at
> http://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.
