Can you check trunk? I just submitted a patch that should have fixed this problem. The price: slower table initilization but perhaps negligible.
On Friday, November 30, 2012 8:51:06 AM UTC-6, Richard wrote: > > I open an issue in the pass about that. > > http://code.google.com/p/web2py/issues/detail?id=382 > > Richard > > On Fri, Nov 30, 2012 at 8:50 AM, Anthony <abas...@gmail.com > <javascript:>>wrote: > >> The format argument goes in the define_table() call -- is that where you >> have it? >> >> Anthony >> >> On Friday, November 30, 2012 1:58:09 AM UTC-5, Luc Chase wrote: >>> >>> Thanks for the suggestion. I had tried something similar but got an >>> error and even with this I have an error referencing to the unexpected use >>> of 'format'. >>> >>> >>> <type 'exceptions.TypeError'> __init__() got an unexpected keyword >>> argument 'format' VERSION web2py™ (2, 2, 1, datetime.datetime(2012, 10, >>> 21, 16, 57, 4), 'stable') PythonPython 2.7: C:\Program >>> Files\Python\web2py_win\**web2py\web2py.exe TRACEBACK >>> >>> 1. >>> 2. >>> 3. >>> 4. >>> 5. >>> >>> Traceback (most recent call last): >>> File "gluon/restricted.py", line 212, in restricted >>> >>> File "C:/Program >>> Files/Python/web2py_win/**web2py/applications/Timesheet/**models/db_wizard.py" >>> <http://127.0.0.1:8000/admin/default/edit/Timesheet/models/db_wizard.py>, >>> line 40, in <module> >>> TypeError: __init__() got an unexpected keyword argument 'format' >>> >>> ERROR SNAPSHOT [image: help] >>> >>> <type 'exceptions.TypeError'>(__**init__() got an unexpected keyword >>> argument 'format') >>> >>> On Thursday, 29 November 2012 02:08:58 UTC, Massimo Di Pierro wrote: >>>> >>>> The problem is that it cannot assign the default validator unless the >>>> table is defined. You can do >>>> >>>> db.define_table('t_project', >>>> Field('f_name', type='string', >>>> label=T('Name')), >>>> Field('f_parent_project', type='reference t_project', >>>> label=T('Parent Project')), >>>> .... >>>> format='%(f_name)s', >>>> migrate=settings.migrate) >>>> >>>> db.t_project.f_name.requires = >>>> IS_EMPTY_OR(IS_IN_DB(db,'t_**project.id<http://t_project.id> >>>> ',format=db.t_**project._format)) >>>> >>>> The last line will restore the dropdown. >>>> >>>> >>>> On Wednesday, 28 November 2012 14:39:14 UTC-6, Jim S wrote: >>>>> >>>>> I'm seeing this as well. >>>>> >>>>> -Jim >>>>> >>>>> >>>>> On Tuesday, November 27, 2012 12:09:18 PM UTC-6, Luc Chase wrote: >>>>>> >>>>>> If the reference is to a different table, the CRUD form renders the >>>>>> field as a list box allowing the user to select the record from the >>>>>> foreign >>>>>> table. But as a self-join the CRUD form renders the field as a simple >>>>>> text >>>>>> box and it seems to create a default value of 0 when saved. Then, I >>>>>> think >>>>>> that causes the record to generate an error when viewed ( but not when >>>>>> edited). >>>>>> >>>>>> >>>>>> I can post the entire models file if that would help. >>>>>> >>>>> -- >> >> >> >> > > --
