slite does not enforce column types. web2py tries to do it.
On Nov 7, 5:26 am, Hans Murx <[email protected]> wrote:
> 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 [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
-~----------~----~----~----~------~----~------~--~---
