Ask again when you are ready I have little app dedicated to check for this issue.
Richard On Fri, Nov 30, 2012 at 10:10 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > 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<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_**pro** >>>>>> ject.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. >>>>>>>> >>>>>>> -- >>>> >>>> >>>> >>>> >>> >>> -- > > > > --