[web2py] Re: Problem with DAL query self join

2012-09-20 Thread Massimo Di Pierro
If you send me the models I wil try it. On Thursday, 20 September 2012 09:40:01 UTC-5, Pradeeshnarayan wrote: > > I have rechecked again. There is a valid field rlord in tbl_objects. > > You can see the field 'tbl_objects.rlord' in the 6th line of SQL query. > SQL is working fine. > > In the erro

[web2py] Re: Problem with DAL query self join

2012-09-20 Thread Pradeeshnarayan
I have rechecked again. There is a valid field rlord in tbl_objects. You can see the field 'tbl_objects.rlord' in the 6th line of SQL query. SQL is working fine. In the error description I have noticed a difference. " File "/var/www/vhosts/astrozon/web2py/applications/astrozon/controllers/hor

[web2py] Re: Problem with DAL query self join

2012-09-20 Thread Massimo Di Pierro
I do not not know but in the DAL query I see: db.tbl_objects.rlord In the original query I see tbl_objects.horid and tbl_alt_objects.rlord but not tbl_objects.rlord. I do not know the model but I suspect you simply have some typos. On Thursday, 20 September 2012 06:35:31 UTC-5, Pradeeshnarayan