This is a config issue on MSSQL side. The datatime fields have to be in ISO format.
Massimo On Jul 25, 7:50 am, Michael <[email protected]> wrote: > Using a modified auto.py, I created a db.py model for a legacy SQL > Server db and just successfully connected to the database using > web2py. However, when I query any table that contains a datetime > datatype, I get the following error: > > Traceback (most recent call last): > File "C:\web2py\gluon\restricted.py", line 176, in restricted > exec ccode in environment > File "C:/web2py/applications/fcs/views/appadmin.html", line 122, in > <module> > File "C:\web2py\gluon\sqlhtml.py", line 918, in __init__ > for (rc, record) in enumerate(sqlrows): > File "C:\web2py\gluon\sql.py", line 2433, in __iter__ > yield self[i] > File "C:\web2py\gluon\sql.py", line 2373, in __getitem__ > str(value)[:10].strip().split('-')] > ValueError: invalid literal for int() with base 10: '' > > In sql.py it seems that web2py expects to see datetime in the format > YYYY-MM-DD HH:MM:SS. SQL Server presents the data in the format MM/DD/ > YYYY HH:MM:SS. I'm brand new to web2py so I don't know whether this > is a bug in data handling or a config. problem on my end. My > understanding is that SQL Server stores a datetime in its own internal > format but formats the data based on locale so it cannot be modified > globally. > > Here's a sample of one table def in db.py: > > db.define_table('Announcement', > SQLField('startTime','datetime'), > SQLField('endTime','datetime'), > SQLField('announcementDate','datetime'), > SQLField('announcementText','string'), > SQLField('announcementType','nchar'), > SQLField('modifyUser','char'), > SQLField('modifyDate','datetime',default=now), > migrate=False) > > Announcement_labels={'startTime':T('startTime'),'endTime':T > ('endTime'),'AnnouncementDate':T > ('AnnouncementDate'),'AnnouncementText':T > ('AnnouncementText'),'AnnouncementType':T > ('AnnouncementType'),'ModifyUser':T('ModifyUser'),'ModifyDate':T > ('ModifyDate')} > > Any ideas about how to address this problem? > > -Michael --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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 -~----------~----~----~----~------~----~------~--~---
