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
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
"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