Hello, I am trying to change the address of a party using the database 
cursor, below is the SQL statement but its not working.

cursor.execute('UPDATE party_address '
            'SET country = 111, '
            'street = "pen" '
            'WHERE party = 111')

#below is the error message i keep receiving

res = self.cursor.execute(sql)
psycopg2.ProgrammingError: column "pen" does not exist
LINE 1: UPDATE party_address SET country = 111, street = "pen" WHERE...

Reply via email to