I found the source of my problem. I have records with null values. And since sqlite don't enforce data typing, I assume that it simply "guess" the data type, based on whatever is found in the first(???) record.
On this assumption, I assigned datetime values in the empty datetime fields and tested again. It's now working. On May 26, 10:19 pm, Nik <[email protected]> wrote: > Traceback (most recent call last): > File "/home/ern/web2py/gluon/restricted.py", line 107, in restricted > exec ccode in environment > File "/home/ern/web2py/applications/smb/views/appadmin.html", line > 122, in <module> > File "/home/ern/web2py/gluon/sqlhtml.py", line 623, in __init__ > for (rc, record) in enumerate(sqlrows): > File "/home/ern/web2py/gluon/sql.py", line 2196, in __iter__ > yield self[i] > File "/home/ern/web2py/gluon/sql.py", line 2151, in __getitem__ > str(value)[:10].strip().split('-')] > ValueError: invalid literal for int() with base 10: '' > > I was trying to go to database administration of db2 when I got this > error. The table is defined as follows: > > db2.define_table('msg_log', > SQLField('type', 'string'), > SQLField('smsc', 'string'), > SQLField('sent', 'datetime'), > SQLField('received', 'datetime'), > SQLField('sender', 'string'), > SQLField('receiver', 'string'), > SQLField('msgid', 'string'), migrate=False) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
