>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'))
>>>>>>
>>>>>>
--
<<attachment: dog.png>>
<<attachment: cat.png>>
