I will during the weekend.
Thank you Massimo
Richard
On Fri, Nov 5, 2010 at 4:09 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
> 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
