Re: [web2py] Re: Self-joins not working.

2012-12-02 Thread Luc Chase
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', > Fi

Re: [web2py] Re: Self-joins not working.

2012-12-01 Thread Luc Chase
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, 201

Re: [web2py] Re: Self-joins not working.

2012-11-30 Thread Luc Chase
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('Descripti

Re: [web2py] Re: Self-joins not working.

2012-11-30 Thread Richard Vézina
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

Re: [web2py] Re: Self-joins not working.

2012-11-30 Thread Massimo Di Pierro
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,

Re: [web2py] Re: Self-joins not working.

2012-11-30 Thread Massimo Di Pierro
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/det

Re: [web2py] Re: Self-joins not working.

2012-11-30 Thread Richard Vézina
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 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

Re: [web2py] Re: Self-joins not working.

2012-11-30 Thread Anthony
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 unexpe

Re: [web2py] Re: Self-joins not working.

2012-11-29 Thread Luc Chase
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'. __init__() got an unexpected keyword argument 'format'VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable')PythonPython

Re: [web2py] Re: Self-joins not working.

2012-11-28 Thread Massimo Di Pierro
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')),

Re: [web2py] Re: Self-joins not working.

2012-11-28 Thread Jim S
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 rende

Re: [web2py] Re: Self-joins not working.

2012-11-27 Thread Luc Chase
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 r

[web2py] Re: Self-joins not working.

2012-11-27 Thread Massimo Di Pierro
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_wi