Hi all I have this function: def checkNameDob(self, name, dob): cur = self.conn.cursor();
sql = "SELECT * from patient WHERE fn_pat = %s" cur.execute(sql,(name)) rows = cur.fetchall() It seems to work fine, But I'm getting this exception: psycopg2.ProgrammingError: current transaction is aborted, commands ignored until end of transaction block at: cur.execute(sql) What's the problem? thx ps: fn_pat is the column of the db, name is the string passed in the function parameter. if I type: "SELECT * from patient WHERE fn_pat = 'david' " in the psql on console it works well...