Correction. Not fixed. On Friday, November 30, 2012 9:10:30 AM UTC-6, Massimo Di Pierro wrote: > > 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> 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. >>>>>>> >>>>>> -- >>> >>> >>> >>> >> >>
--