please show us your code (the one you're using for inserting the value), and the model... so we can track down the anomaly
On Friday, February 13, 2015 at 12:31:44 AM UTC+1, MDSIII wrote: > > I'm inserting a row with a value for a datetime type field such as > '2015-02-12T14:43:52.113000'. > > The DAL lets me do the insert but errors in the adapter when I do a select > that includes this row/column. > > I realize the string does not match the datetime.isoformat(' ') that the > dbapi adapter expects on read but why doesn't it also do validation on > write. > > I suspect the answer is to do my own type checking or leverage default > SQLFORM validator? > > Thanks, > Max > -- 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. For more options, visit https://groups.google.com/d/optout.