Re: [Tutor] sqlite3 Python25 parameter binding problem with UPDATEplease help

2008-12-02 Thread aivars
Hello again, Finally I managed to get it working! I had to remove [year] braces from the second argument - year. The reason I used [] was the posts we exchanged recently (7th of November) about CGI script where it was recommended by Kent that I put [] around string argument: Quote The second arg

Re: [Tutor] sqlite3 Python25 parameter binding problem with UPDATEplease help

2008-12-02 Thread aivars
Interestingly, when simply testing like this: import sqlite3, sys sPATH=r'e:\pythonexamples\aivars2.db' oCon=sqlite3.connect(sPATH) cur=oCon.cursor() oCon.execute("""UPDATE rezerve SET latusaldo = ? WHERE gads = ? """,(6000.0,'2006')) oCon.commit() it works. Therefore I am stuck since it look

Re: [Tutor] sqlite3 Python25 parameter binding problem with UPDATEplease help

2008-12-02 Thread Alan Gauld
"aivars" <[EMAIL PROTECTED]> wrote oCon.execute("UPDATE rezerve SET latusaldo =? where gads =?;",(result, [year])) oCon.commit() it throws me the error: sqlite3.InterfaceError: error binding parameter 1 probably unsupported type I assume its the [year] value it objects to. I'm not sure wha