Did that:

>>> db = DAL("sqlite://db.db")
>>> db.define_table("t1", Field("f1", "date"))
>>> db.t1.insert(f1="a")
1
>>> db.t1[1].f1
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "gluon/sql.py", line 1468, in __getitem__
  File "gluon/sql.py", line 2883, in select
  File "gluon/sql.py", line 2927, in parse
ValueError: invalid literal for int() with base 10: 'a'
>>>

Shows, that we can insert rows that can't be selected. Is this ok?

Why does sqlite except "a" as as date?

Regards

  Hans

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to