On Sat, 04 Oct 2014 10:44:20 -0400, Mark Halegua
<[email protected]> wrote:
> self.cdata.execute('insert into publishers(publisher_name,
>remarks) values("test", "remarks");')
Are you sure this is correct?
In SQL, string literals are delimited by single quotes.
Double quotes can be used around identifiers, like column names.
Double quotes are necessary when an identifier happens to be a
keyword or contains uncommon characters (e.g. spaces).
I know next to nothing about python, but in the pysqlite docs, I
find examples like:
# Insert a row of data
c.execute("""insert into stocks
values ('2006-01-05','BUY','RHAT',100,35.14)""")
https://pysqlite.readthedocs.org/en/latest/sqlite3.html
No idea whether that solves your problem.
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
