Re: [web2py] Re: Fail to add entry to list:reference field

2013-04-07 Thread 冷春辉
Hi Anthony, I compared the layout.html against older version, the jQuery issue was resulted because I manually add: (I thought jQuery was not included in Layout.html) Removing this line solved the problem. Also I will try to build a custom widget. Thank a lot. Spring On Mon, Apr 8, 2013 at 1:0

Re: [web2py] Re: Fail to add entry to list:reference field

2013-04-07 Thread Anthony
> > The intention is to create a list of items each of which are selected from > the dropdown of referenced table, similar to 'list:string' with a "+/-" > sign at the end to add another item. When click the "+/-" sign it pops > another dropdown list to add new item. I photoshoped the pic below

Re: [web2py] Re: Fail to add entry to list:reference field

2013-04-07 Thread 冷春辉
The intention is to create a list of items each of which are selected from the dropdown of referenced table, similar to 'list:string' with a "+/-" sign at the end to add another item. When click the "+/-" sign it pops another dropdown list to add new item. I photoshoped the pic below to show what I

Re: [web2py] Re: Fail to add entry to list:reference field

2013-04-07 Thread Anthony
> > > I read in the book that "requires' will be set by default for > "list:reference". I tried this, and the output is the same as with > IS_IN_DB(..., > multiple=True), which is a multiple item box listing all options as shown > in the pic below: > [image: Inline image 1] > The above looks

Re: [web2py] Re: Fail to add entry to list:reference field

2013-04-07 Thread Massimo Di Pierro
Reference fields are long integers. >>> a = 1 >>> print a 1 >>> print repr(a) 1 >>> b = 1L >>> print b 1 >>> print repr(b) 1L read more: http://stackoverflow.com/questions/2104884/how-does-python-manage-int-and-long For practical purpose they are the same but with long integers you do not run

Re: [web2py] Re: Fail to add entry to list:reference field

2013-04-07 Thread 冷春辉
Hi Anthony, I read in the book that "requires' will be set by default for "list:reference". I tried this, and the output is the same as with IS_IN_DB(..., multiple=True), which is a multiple item box listing all options as shown in the pic below: [image: Inline image 1] And I still don't understan

[web2py] Re: Fail to add entry to list:reference field

2013-04-07 Thread Anthony
> > Field('f_keypersons', type='list:reference t_contacts', requires= > IS_IN_DB(db, 't_contacts.id', '%(f_name)s'), For list:reference fields, it should be IS_IN_DB(..., multiple=True). Actually, you shouldn't need to set the "requires" attribute explicitly anyway because you will get IS_