Tested "print type(idrow)" and it says <type 'unicode'>
Here the schema of my table:
id : integer primary key autoincrement
So idrow has to be converted to an integer. Hopefully you can see why. Also, are you using Python 3.X?
try:
idrow_int = int(idrow)
self.cur.execute("select titre, code, date from codes where id=:d_key", {"d_key":idrow_int})
## etc.
except:
print idrow, "can not be converted to an integer"