I do not know. Can you try the latest version?
On Jul 5, 12:28 pm, JohnMc <[email protected]> wrote:
> I receive the following error when I attempt to access the table below
> with 'database administration'. Form works fine. Using Web2py 1.63
>
> Error traceback
>
> Traceback (most recent call last):
> File "/home/rootuser/New/gluon/restricted.py", line 107, in
> restricted
> File "/home/rootuser/Helix/applications/Helix/views/appadmin.html",
> line 106, in <module>
> File "/home/rootuser/New/gluon/sqlhtml.py", line 626, in __init__
> File "/home/rootuser/New/gluon/sql.py", line 2333, in __iter__
> File "/home/rootuser/New/gluon/sql.py", line 2273, in __getitem__
> ValueError: need more than 1 value to unpack
>
> Model:
> -------------------------------------------
> assets.define_table('stocks',
> assets.Field('symbl','string'),
> assets.Field('basis','boolean'),
> assets.Field('action','string'),
> assets.Field('qrydate','datetime',default=stamp),
> assets.Field('lasttrade','double'),
> assets.Field('trdtime','string'),
> assets.Field('chgval','double'),
> assets.Field('chgpct','double'),
> assets.Field('yrest','double'),
> assets.Field('bid','double'),
> assets.Field('ask','double'),
> assets.Field('dayrangelow','double'),
> assets.Field('dayrangehigh','double'),
> assets.Field('yrrangelow','double'),
> assets.Field('yrrangehigh','double'),
> assets.Field('dayvol','double'),
> assets.Field('avgvol','double'),
> assets.Field('marketcap','string'),
> assets.Field('pe','double'),
> assets.Field('eps','double'),
> assets.Field('div','double'),
> assets.Field('yld','double')
> )
>
> assets.stocks.symbl.requires = IS_NOT_EMPTY(error_message='Must not be
> empty')
> assets.stocks.lasttrade.requires = IS_NOT_EMPTY(error_message='Must
> not be empty')
> assets.stocks.action.requires = IS_IN_SET
> (['buy','sell','hold','trade','gift'])
>
> Any suggestions? Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
