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
-~----------~----~----~----~------~----~------~--~---
