On Wednesday, June 3, 2020 at 2:04:02 PM UTC-7, Seth J wrote: > > I am not sure how to view the query sent to MSSQL. >
Does this help/? <URL:https://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#_lastsql> > Here's a little more from the error record: > > > - > > *File C:\inetpub\wwwroot\gluon\packages\dal\pydal\adapters\base.py in > insert at line 539* code arguments variables > Function argument list > > (self=<pydal.adapters.mssql.MSSQL4 object>, table=<Table > web2py_session_PubView (id, locked, clien...me, modified_datetime, > unique_key, session_data)>, fields=[(<pydal.objects.Field object>, > '172.20.145.208'), (<pydal.objects.Field object>, 0), > (<pydal.objects.Field > object>, '2020-06-03T00:26:05.296000'), (<pydal.objects.Field object>, > 'affc9c47-0085-45dc-8352-12549c7f93dc'), (<pydal.objects.Field object>, > datetime.datetime(2020, 6, 3, 0, 26, 5, 296000)), (<pydal.objects.Field > object>, > > '\x80\x02cgluon.globals\nSession\nq\x01}q\x02U\x05flashq\x03U\x00s\x85Rq\x04.')]) > > You've got a date conversion error. Do you need to specify a format string? Is the ISO 'T' causing problems with a format that expects a space? How have you defined the field? /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/1535949d-38d4-4bd5-9cb4-3a4adfa578b5%40googlegroups.com.