That one seems fixed, but on insert: Traceback (most recent call last): File "C:\web2py\hg\gluon\restricted.py", line 173, in restricted exec ccode in environment File "C:/web2py/hg/applications/nav3/controllers/appadmin.py", line 305, in <module> File "C:\web2py\hg\gluon\globals.py", line 96, in <lambda> self._caller = lambda f: f() File "C:/web2py/hg/applications/nav3/controllers/appadmin.py", line 124, in insert if form.accepts(request.vars, session): File "C:\web2py\hg\gluon\sqlhtml.py", line 898, in accepts self.vars.id = self.table.insert(**fields) File "C:\web2py\hg\gluon\sql.py", line 1890, in insert self._db._adapter.execute(query) File "C:\web2py\hg\gluon\sql.py", line 969, in execute return self.cursor.execute(command) DataError: ('22008', '[22008] [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0180 - Syntax of date, time, or timestamp value not valid. (-180) (SQLExecDirectW)')
On Dec 14, 9:39 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > This I fixed, please try again. Thanks Denes. Your tests help a lot. > > On Dec 14, 8:27 am, DenesL <denes1...@yahoo.ca> wrote: > > > Also, testing DB2: > > > Traceback (most recent call last): > > File "C:\web2py\hg\gluon\restricted.py", line 173, in restricted > > exec ccode in environment > > File "C:/web2py/hg/applications/nav3/models/db.py", line 5, in > > <module> > > dot4=SQLDB('db2:DSN=dot4;UID=web2py;PWD=xxx') > > File "C:\web2py\hg\gluon\sql.py", line 1301, in __init__ > > self._adapter = ADAPTERS[self._dbname] > > (uri,pool_size,folder,db_codec) > > File "C:\web2py\hg\gluon\sql.py", line 949, in __init__ > > cnxn = self._uri.split(':', 1)[1] > > AttributeError: 'DB2Adapter' object has no attribute '_uri' -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.