Re: [web2py] Re: Self-joins not working.
It works fine if I remove 'format=' db.t_project.f_parent_project.requires = IS_EMPTY_OR(IS_IN_DB(db,' t_project.id',db.t_project._format)) -- Luc. On Saturday, 1 December 2012 07:57:16 UTC, Luc Chase wrote: 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')), Field('f_description', type='string', label=T('Description')), Field('f_start_on', type='date', label=T('Start On')), Field('f_colour', type='string', label=T('Colour')), Field('f_company_code', type='text', label=T('Company Code')), Field('f_status', type='boolean', label=T('Status')), auth.signature, format='%(f_name)s', migrate=settings.migrate) db.t_project.f_parent_project.requires = IS_EMPTY_OR(IS_IN_DB(db,' t_project.id',format=db.t_project._format)) db.define_table('t_project_archive',db.t_project,Field('current_record','reference t_project',readable=False,writable=False)) On Friday, 30 November 2012 13:50:34 UTC, Anthony 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'VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable')PythonPython 2.7: C:\Program Files\Python\web2py_win\web2py\web2py.exeTRACEBACK 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 ',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. --
Re: [web2py] Re: Self-joins not working.
Would the test include a test of the Wizard's ability to implement this? The error first surfaced there. -- Luc. On Friday, 30 November 2012 15:15:39 UTC, Richard wrote: 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@gmail.comjavascript: 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=382http://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. -- -- --
Re: [web2py] Re: Self-joins not working.
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'VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable')PythonPython 2.7: C:\Program Files\Python\web2py_win\web2py\web2py.exeTRACEBACK 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 ',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. --
Re: [web2py] Re: Self-joins not working.
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 abasta...@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'VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable')PythonPython 2.7: C:\Program Files\Python\web2py_win\**web2py\web2py.exeTRACEBACK 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.idhttp://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. -- --
Re: [web2py] Re: Self-joins not working.
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.idhttp://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. -- --
Re: [web2py] Re: Self-joins not working.
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.idhttp://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. -- --
Re: [web2py] Re: Self-joins not working.
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=382http://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. -- -- --
Re: [web2py] Re: Self-joins not working.
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')), Field('f_description', type='string', label=T('Description')), Field('f_start_on', type='date', label=T('Start On')), Field('f_colour', type='string', label=T('Colour')), Field('f_company_code', type='text', label=T('Company Code')), Field('f_status', type='boolean', label=T('Status')), auth.signature, format='%(f_name)s', migrate=settings.migrate) db.t_project.f_name.requires = IS_EMPTY_OR(IS_IN_DB(db,'t_project.id',format =db.t_project._format)) db.define_table('t_project_archive',db.t_project,Field('current_record','reference t_project',readable=False,writable=False)) On Friday, 30 November 2012 13:50:34 UTC, Anthony 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'VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable')PythonPython 2.7: C:\Program Files\Python\web2py_win\web2py\web2py.exeTRACEBACK 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 ',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. --
Re: [web2py] Re: Self-joins not working.
Thanks for the suggestion. I had tried something similar but got an error and even with this I have an referrering to the unexpected use of 'format'. type 'exceptions.TypeError' __init__() got an unexpected keyword argument 'format'VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable')PythonPython 2.7: C:\Program Files\Python\web2py_win\web2py\web2py.exeTRACEBACK 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 ',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. --
Re: [web2py] Re: Self-joins not working.
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. --
Re: [web2py] Re: Self-joins not working.
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',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. --
[web2py] Re: Self-joins not working.
In which way this is not working correctly? On Monday, 26 November 2012 12:45:22 UTC-6, Luc Chase wrote: The documentation at http://web2py.com/books/default/chapter/29/06?search=reference#Self-Reference-and-aliases says that this should be possible. However my models code in db_wizard.py which I've partially edited just for this requirement does not generate the correct CRUD form ( a lookup list-box). What do I need to change to make this work correctly? Here is my models code... 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')), Field('f_description', type='string', label=T('Description')), Field('f_start_on', type='date', label=T('Start On')), Field('f_colour', type='string', label=T('Colour')), Field('f_company_code', type='text', label=T('Company Code')), Field('f_status', type='boolean', label=T('Status')), auth.signature, format='%(f_name)s', migrate=settings.migrate) --
Re: [web2py] Re: Self-joins not working.
If the reference is to a different table, the CRUD renders the field as a list box allowing the user to select the record in the foreign table. But as a self-join the CRUD 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). On 27 November 2012 14:23, Massimo Di Pierro massimo.dipie...@gmail.comwrote: In which way this is not working correctly? On Monday, 26 November 2012 12:45:22 UTC-6, Luc Chase wrote: The documentation at http://web2py.com/books/**default/chapter/29/06?search=** reference#Self-Reference-and-**aliaseshttp://web2py.com/books/default/chapter/29/06?search=reference#Self-Reference-and-aliases says that this should be possible. However my models code in db_wizard.py which I've partially edited just for this requirement does not generate the correct CRUD form ( a lookup list-box). What do I need to change to make this work correctly? Here is my models code... 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')), Field('f_description', type='string', label=T('Description')), Field('f_start_on', type='date', label=T('Start On')), Field('f_colour', type='string', label=T('Colour')), Field('f_company_code', type='text', label=T('Company Code')), Field('f_status', type='boolean', label=T('Status')), auth.signature, format='%(f_name)s', migrate=settings.migrate) -- -- Luc. M. +44.7040-901-582 --