db.executesql("INSERT INTO TBLB (PersonID, LastName, FirstName, Address)
VALUES (test, example, tutorial, release)")
should be
db.executesql("INSERT INTO TBLB (PersonID, LastName, FirstName, Address)
VALUES ('test', 'example', 'tutorial', 'release')")
On Friday, 4 October 2013 07:52:34 UTC-5, loïc lauréote wrote:
>
> Hi, i use dal.py and for sqlite i have an inversion.
> Do you have the same problem ?
> thx
>
> message : test column doesn't exist.
> conf : windows 7, python27
>
> *source code :*
>
> import re
> from dal import DAL, Field
>
>
>
> if __name__ == '__main__':
> db =
> DAL(('sqlite://openbioreactor.sqlite','mysql://a:b@localhost/x'),folder=None)
> db.executesql("CREATE TABLE TBLB (PersonID int,LastName
> varchar(255),FirstName varchar(255),Address varchar(255))")
> db.executesql("INSERT INTO TBLB (PersonID, LastName, FirstName, Address)
> VALUES (test, example, tutorial, release)")
> db.commit()
>
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
