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 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 hope we can find the problem or find another way to do the dropdown
> which works on db2.
>
> 1. create table below
> models/db_tables.py
>
> -------------------------------------------------------------------------------------------------
>
> # coding: utf8
>
> db.define_table('dog',
> Field('dogid'),
> Field('name'),
> format='%(name)s',
> primarykey=['dogid'])
>
> db.define_table('cat',
> Field('catid'),
> Field('name'),
> format='%(name)s',
> primarykey=['catid'])
>
> db.define_table('person',
> Field('personid'),
> Field('name'),
> Field('mydog'),
> Field('mycat'),
> format='%(name)s',
> primarykey=['personid'])
>
> db.person.mydog.requires=IS_IN_DB(db,db.dog.dogid,'%(name)s')
> db.person.mycat.requires=IS_IN_DB(db,db.cat.catid,'%(name)s')
>
> -------------------------------------------------------------------------------------------------
>
> 2. create the table on db2 from dds
>
> person
> -------------------------------------------------
> A*
> A R PERSONR
> A*
> A PERSONID 5A
> A NAME 50A
> A MYDOG 5A
> A MYCAT 5A
> A*
> A* KEY FIELDS
> A*------------
> A K PERSONID
> A*
> -------------------------------------------------
>
> Dog
> -------------------------------------------------
> A*
> A R DOGR
> A*
> A DOGID 5A
> A NAME 50A
> A*
> A* KEY FIELDS
> A*------------
> A K DOGID
> A*
> -------------------------------------------------
>
> Cat
> -------------------------------------------------
> A*
> A R CATR
> A*
> A CATID 5A
> A NAME 50A
> A*
> A* KEY FIELDS
> A*------------
> A K CATID
> A*
> -------------------------------------------------
>
> 3. Insert test data
> -------------------------------------------------
> Dog
> dogid = '12345'
> name = 'HACHI'
>
> Cat
> catid='CAT01'
> name = 'TAMA'
> -------------------------------------------------
>
> 4. Result
> I can pull the data from Dog table but not Cat table (see attached)
> As you can see the dog and cat table is exactly the same type of table but
> dog has data begin with number
> and cat begin with alphabet.
>
>
>
>
> On Sunday, August 19, 2012 10:08:07 AM UTC-5, Massimo Di Pierro wrote:
>>
>> 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, 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 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 field begin with
>>>>> numeric numbers for example 12345 or 1ABCDE (See NG-1,2.jpg)
>>>>> but cannot pull the data begin with alphabet like A1234. (See
>>>>> OK-1,2.jpg)
>>>>>
>>>>>
>>>>> # MF - EDI CUSTOMER
>>>>> db.define_table('EDMACF00',
>>>>> Field('ACDIID', length=5, label="Dist Code"),
>>>>> Field('ACNAME', length=20, label="Dist Name"),
>>>>> Field('AC855F', length=1, label="PO ACK FLAG"),
>>>>> Field('AC856F', length=1, label="ASN FLAG"),
>>>>> Field('AC810F', length=1, label="INVOICE FLAG"),
>>>>> Field('ACUPFL', length=1, label="OZ UPLOAD FLAG"),
>>>>> Field('ACCRBY', length=20, default = auth.user.username.upper() if
>>>>> auth.user else None, label="Created by"),
>>>>> Field('ACCRDT', 'datetime', default =request.now, label="Created
>>>>> on"),
>>>>> Field('ACUPBY', length=20, update = auth.user.username.upper() if
>>>>> auth.user else None, label="Updated by"),
>>>>> Field('ACUPDT', 'datetime', update =request.now, label="Updated
>>>>> on"),
>>>>> primarykey=['ACDIID'])
>>>>>
>>>>> db.EDMACF00.ACDIID.requires=[IS_NOT_EMPTY(),IS_LENGTH(5,1),IS_UPPER()]
>>>>> db.EDMACF00.ACNAME.requires=[IS_NOT_EMPTY(),IS_LENGTH(20,1),IS_UPPER()]
>>>>> db.EDMACF00.AC855F.requires=IS_IN_SET(['','1'], zero=None)
>>>>> db.EDMACF00.AC856F.requires=IS_IN_SET(['','1'], zero=None)
>>>>> db.EDMACF00.AC810F.requires=IS_IN_SET(['','1'], zero=None)
>>>>> db.EDMACF00.ACUPFL.writable = db.EDMACF00.ACUPFL.readable = False
>>>>> db.EDMACF00.ACCRBY.writable = False
>>>>> db.EDMACF00.ACCRDT.writable = False
>>>>> db.EDMACF00.ACUPBY.writable = False
>>>>> db.EDMACF00.ACUPDT.writable = False
>>>>>
>>>>> # XR - CUSTOMER
>>>>> db.define_table('EDXTKF00',
>>>>> Field('TKDIID', length=5, label="Dist Code"),
>>>>> Field('TKDICD', length=20, label="Dist Office Code"),
>>>>> Field('TKTKSC', length=3, label="Dept"),
>>>>> Field('TKTKCD', length=8, label="Customer Code"),
>>>>> Field('TKDMCD', 'integer', label="Employee Code"),
>>>>> Field('TKUPFL', length=1, label="OZ UPLOAD FLAG"),
>>>>> Field('TKCRBY', length=20, default = auth.user.username.upper() if
>>>>> auth.user else None, label="Created by"),
>>>>> Field('TKCRDT', 'datetime', default =request.now, label="Created
>>>>> on"),
>>>>> Field('TKUPBY', length=20, update = auth.user.username.upper() if
>>>>> auth.user else None, label="Updated by"),
>>>>> Field('TKUPDT', 'datetime', update =request.now, label="Updated
>>>>> on"),
>>>>> primarykey=['TKDIID', 'TKDICD'])
>>>>>
>>>>>
>>>>> db.EDXTKF00.TKDIID.requires=IS_IN_DB(db,db.EDMACF00.ACDIID,'%(ACNAME)s')
>>>>> db.EDXTKF00.TKDICD.requires=[IS_NOT_EMPTY(),IS_LENGTH(20,1),IS_UPPER()]
>>>>>
>>>>> db.EDXTKF00.TKTKSC.requires=IS_IN_SET(['J11','J13','J14','J15','J16','J17'])
>>>>>
>>>>> db.EDXTKF00.TKTKCD.requires=[IS_NOT_EMPTY(),IS_LENGTH(8,8),IS_UPPER(),IS_IN_DB(db,db.CDMTKL00.TKTSCD)]
>>>>> db.EDXTKF00.TKDMCD.requires=[IS_NOT_EMPTY(),IS_INT_IN_RANGE(60000,69999,error_message='Invalid
>>>>>
>>>>> length'),IS_IN_DB(db,db.CDMSYL00.SYSYCD)]
>>>>> db.EDXTKF00.TKUPFL.writable = db.EDXTKF00.TKUPFL.readable = False
>>>>> db.EDXTKF00.TKCRBY.writable = False
>>>>> db.EDXTKF00.TKCRDT.writable = False
>>>>> db.EDXTKF00.TKUPBY.writable = False
>>>>> db.EDXTKF00.TKUPDT.writable = False
>>>>>
>>>>>
>>>>> On Friday, August 17, 2012 4:38:00 PM UTC-5, Omi Chiba wrote:
>>>>>>
>>>>>> 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.
>>>>>>
>>>>>> db.EDXTKF00.TKDIID.requires=IS_IN_DB(db,db.EDMACF00.ACDIID)
>>>>>> =>
>>>>>> db.EDXTKF00.TKDIID.requires=IS_IN_DB(db,'EDMACF00.ACDIID')
>>>>>>
>>>>>> On Friday, August 17, 2012 4:20:42 PM UTC-5, 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 = IS_IN_DB(db, 'person.id', '%(name)s',
>>>>>>> zero=T('choose one'))
>>>>>>>
>>>>>>>
--
