[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-22 Thread Omi Chiba
Like can I query the data from the table and use IS_IN_SET istead of IS_IN_DB ? On Tuesday, August 21, 2012 4:54:51 PM UTC-5, Omi Chiba wrote: Is there any other way I can try ? I can see the data in the both table no problem. It just cannot use IS_IN_DB function for it. On Monday,

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-22 Thread Massimo Di Pierro
You can but it should be very inefficient. On Wednesday, 22 August 2012 15:01:44 UTC-5, Omi Chiba wrote: Like can I query the data from the table and use IS_IN_SET istead of IS_IN_DB ? On Tuesday, August 21, 2012 4:54:51 PM UTC-5, Omi Chiba wrote: Is there any other way I can try ? I

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-21 Thread Omi Chiba
Is there any other way I can try ? I can see the data in the both table no problem. It just cannot use IS_IN_DB function for it. On Monday, August 20, 2012 2:33:39 PM UTC-5, Omi Chiba wrote: Is the problem only in appadmin? No, it happnes anywhere. Can you produce a minimum program with

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-20 Thread Omi Chiba
Is the problem only in appadmin? No, it happnes anywhere. Can you produce a minimum program with some sample data to reproduce this? I tried MySQL, MSSQL and DB2, and found only DB2 has this problem. This is how to reproduce the error on db2. This is very critical for my current project and I

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-19 Thread Massimo Di Pierro
Is the problem only in appadmin? Can you produce a minimum program with some sample data to reproduce this? On Friday, 17 August 2012 23:56:39 UTC-5, Omi Chiba wrote: Issue #939 is assigned. http://code.google.com/p/web2py/issues/detail?id=939 On Friday, August 17, 2012 9:51:48 PM UTC-5,

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-17 Thread villas
Specify the field that you wish to appear in the dropdown box Try what the book says, 'name' is simply the name of the field you wish to appear: db.dog.owner.requires = IS_IN_DB(db, 'person.id', '%(name)s', zero=T('choose one')) --

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-17 Thread Anthony
But he's not getting any records at all in the list. On Friday, August 17, 2012 5:20:42 PM UTC-4, villas wrote: Specify the field that you wish to appear in the dropdown box Try what the book says, 'name' is simply the name of the field you wish to appear: db.dog.owner.requires =

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-17 Thread Omi Chiba
Just in case, I changed just like you suggested but I got a same result. I can pull the data from other tables on the same database but I cannot pull the data from this one I should be dreaming or getting crazy... : ( I first doubt a simple typo but I can't figure out.

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-17 Thread Massimo Di Pierro
Please open a ticket pointing to this thread. Will look at it asap. On Friday, 17 August 2012 17:33:51 UTC-5, Omi Chiba wrote: I finally figured this should be a bug on the current in trunk version (Version 2.0.0 (2012-08-15 17:30:38) dev) I can pull the data when the data in primarykey

[web2py] Re: IS_IN_DB cannot pull the data from the table

2012-08-17 Thread Omi Chiba
Issue #939 is assigned. http://code.google.com/p/web2py/issues/detail?id=939 On Friday, August 17, 2012 9:51:48 PM UTC-5, Massimo Di Pierro wrote: Please open a ticket pointing to this thread. Will look at it asap. On Friday, 17 August 2012 17:33:51 UTC-5, Omi Chiba wrote: I finally