I believe this problem was fixed in trunk a few days ago. Did you try
trunk?
Massimo
On Nov 5, 2:11 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
> Oups!
>
> I start with tablelist I forgot to correct it.
>
> It solves the problem default multiselect view un broswer... And banko! We
> can reproduce the first problem I had.
>
> If you change
>
> Field('userselect','list:reference tablelist',notnull=True))
>
> For
>
> Field('userselect','list:reference userlist',notnull=True))
>
> Add some record in userlist then back in name table try to omit the date you
> will have the problem... The default multiselect view will break in case the
> date is omit in the validator is trigged.
>
> With more then 10 record list:reference split the id into single digit :
>
> 10 become 1 and 0
>
> Look at the attachement.
>
> Thanks
>
> Richard
>
> On Fri, Nov 5, 2010 at 2:40 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
> > I do not understand:
>
> > db.define_table('userlist',
> > Field('fname','string',notnull=True),
> > Field('lname','string',notnull=True),
> > format='%(fname)s %(lname)s (%(id)s)')
>
> > db.define_table('name',
> > Field('name','string',notnull=True),
> > Field('date','date',notnull=True),
> > Field('userselect','list:reference tablelist',notnull=True))
>
> > there is no table "tablelist". This
>
> > On Nov 5, 11:24 am, Richard Vézina <ml.richard.vez...@gmail.com>
> > wrote:
> > > Can't reproduce it in a dedicated app.
>
> > > But the list:reference doesn't seems to me to work correctly as it was in
> > > the 1.83.2 in which it was managing a list reprensentation. Now I can't
> > pick
> > > my stuff from a list like in the attached file I sent yesterday. There is
> > > only a empty field.
>
> > > If I try to pass a list of element like : |1|2| it store 0.
>
> > > Pretty strange behavior to me.
>
> > > Attached app.
>
> > > Go to default/create/userlist
> > > Create some user
> > > Then go to default/create/name
> > > See that there is no way to pick the user charged in userlist table
> > > There is also default/read/name/ID where you can see that there no list
> > > stored in case you load |1|2| in create view.
>
> > > Regards
>
> > > Richard
>
> > > On Thu, Nov 4, 2010 at 4:33 PM, mdipierro <mdipie...@cs.depaul.edu>
> > wrote:
> > > > Can you please post the model, the controller and the steps to
> > > > reproduce the problem?
>
> > > > Massimo
>
> > > > On Nov 4, 3:29 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
> > > > > More input on the problem.
>
> > > > > It happen when the date validator is activated. The refresh form not
> > > > expose
> > > > > the normal list field. I reproduce the problem with Chrome and
> > Firefox
> > > > > systematically when the date is forgot and required by the model.
>
> > > > > I attach screenshot of the problem :
>
> > > > > Capture.png = when date validator is activated
>
> > > > > Capature-1.png = normal list selector field
>
> > > > > The main problem is that the id is splited.
>
> > > > > Richard
>
> > > > > On Thu, Nov 4, 2010 at 1:57 PM, Richard Vézina
> > > > > <ml.richard.vez...@gmail.com>wrote:
>
> > > > > > Ok I know what the problem has cause :
>
> > > > > > It seems that the new version is splitting id into single number :
>
> > > > > > 35 = |3|5|
> > > > > > 94 = |9|4|
>
> > > > > > Instead of :
>
> > > > > > 94 = |94|
>
> > > > > > Richard
>
> > > > > > On Thu, Nov 4, 2010 at 12:33 PM, Richard Vézina <
> > > > > > ml.richard.vez...@gmail.com> wrote:
>
> > > > > >> Hello,
>
> > > > > >> I get this error... I have no clue why I get it. I think it not
> > coming
> > > > > >> from my app :
>
> > > > > >> Traceback (most recent call last):
>
> > > > > >> File "/home/www-data/web2py/gluon/restricted.py", line 188, in
> > > > restricted
>
> > > > > >> exec ccode in environment
>
> > > > > >> File
> > "/home/www-data/web2py/applications/init/views/appadmin.html" <
> > > >https://127.0.0.1/admin/default/edit/init/views/appadmin.html>, line
> > 192,
> > > > in <module>
>
> > > > > >> {{=form}}
>
> > > > > >> File "/home/www-data/web2py/gluon/sqlhtml.py", line 1273, in
> > > > __init__
>
> > > > > >> r = field.represent(r)
>
> > > > > >> File "/home/www-data/web2py/gluon/sql.py", line 518, in <lambda>
>
> > > > > >> (ids and ', '.join(f(r,id) for id in ids) or '')
>
> > > > > >> TypeError: sequence item 0: expected string, int found
>
> > > > > >> Error snapshot*Detailed traceback description*
>
> > > > > >> - Exception: <type 'exceptions.TypeError'>(sequence item 0:
> > > > expected
> > > > > >> string, int found)
> > > > > >> - Python 2.6.4: /usr/bin/python
>
> > > > > >> File /home/www-data/web2py/gluon/restricted.py in restricted at
> > line
> > > > 188
> > > > > >> [ code | arguments | variables ] File
> > > > > >> /home/www-data/web2py/applications/init/views/appadmin.html in
> > > > <module> at
> > > > > >> line 192[ code | arguments | variables ] File
> > > > > >> /home/www-data/web2py/gluon/sqlhtml.py in __init__ at line 1273[
> > code
> > > > |
> > > > > >> arguments | variables ] File /home/www-data/web2py/gluon/sql.py in
> > > > > >> <lambda> at line 518[ code | arguments | variables ]
> > > > > >> *Function argument list: (ids=[9, 4], r=<Table {'first_name':
> > > > > >> <gluon.sql.Field object at...itials': <gluon.sql.Field object at
> > > > > >> 0xbb52a50c>}>, f=<function ff at 0xbb1db02c>)*
>
> > > > > >> 513.
> > > > > >> 514.
>
> > > > > >> 515.
> > > > > >> 516.
>
> > > > > >> 517.
>
> > > > > >> 518.
>
> > > > > >> 519.
>
> > > > > >> 520.
> > > > > >> 521.
>
> > > > > >> 522.
>
> > > > > >> elif field._db and field_type.startswith('list:reference') and
> > \
>
> > > > > >> field_type.find('.') < 0 and \
>
> > > > > >> field_type[15:] in field._db.tables:
>
> > > > > >> referenced = field._db[field_type[15:]]
>
> > > > > >> field.represent = lambda ids, r=referenced, f=ff: \
>
> > > > > >> (ids and ', '.join(f(r,id) for id in ids) or '')
>
> > > > > >> if hasattr(referenced, '_format') and referenced._format:
>
> > > > > >> requires = validators.IS_IN_DB(field._db,
> > referenced.id,
>
> > > > referenced._format,multiple=True)
>
> > > > > >> if field.unique:
>
> > > > > >> *
> > > > > >> *
>
> > > > > >> *Richard*
>
> > > > > >> *
> > > > > >> *
>
> > > > > Capture.png
> > > > > 10KViewDownload
>
> > > > > Capture-1.png
> > > > > 12KViewDownload
>
> > > web2py.app.applistissue.w2p
> > > 107KViewDownload
>
>
>
> Capture-2.png
> 64KViewDownload
>
> Capture-3.png
> 69KViewDownload
