-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
nixonron wrote:
> conn = sqlite3.connect("c://Ujimadata//aid.sqlite")
If you are using forward slashes then you only need one. Having more
may cause errors. (Backslashes need two because they are a quoting
character.)
> cursor.execute("UPDATE country SET slug=%s WHERE country_cd=%s",
> (slugify(country_name), country_cd))
[...]
> sqlite3.OperationalError: near "%": syntax error
Hint: What is the difference between these two?
print "slug=%s country=%s", ("us", "usa")
print "slug=%s country=%s" % ("us", "usa")
In any event you should be using Python or pysqlite mailing lists as
none of your issues have anything to do with SQLite.
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
The pysqlite help has several examples you can learn from.
http://oss.itsystementwicklung.de/download/pysqlite/doc/sqlite3.html
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkpTwwYACgkQmOOfHg372QS5CwCfXA/cQuaq1rOt5daZxxyBjRd8
DMkAoN6RnEES29/5z+v2JwaRp6GgPl/b
=vklI
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
