Re: [sqlite] sqlite or python error

2009-07-07 Thread Igor Tandetnik
nixonron wrote: > cursor.execute("UPDATE country SET slug=%s WHERE country_cd=%s", > (slugify(country_name), country_cd)) > conn.commit() > > > Here is the error message > > Traceback (most recent call last): > File "C:\Python25\ron_scripts\newsqlite.py", line 9,

Re: [sqlite] sqlite or python error

2009-07-07 Thread Roger Binns
-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("UPDAT

[sqlite] sqlite or python error

2009-07-07 Thread nixonron
After fixing the connection issue I get a syntax error when trying to connect to a sqlite database and wonder if its python or sqlite. Error message seems to indicate sqlite. I check the code in Komodo and don't get any syntax errors. Here is the code import sqlite3 from sluggy import slugify