AttributeError: 'tuple' object has no attribute 'encode' python gui

Question

I'm having this error AttributeError: 'tuple' object has no attribute 'encode' and here is the part of my code. can you please help me

cur = conn.cursor()
sql = "SELECT * FROM farm_registration \
       WHERE barangay = %s", (e_barangay);
cur.execute(sql)
results = cur.rowcount

Exception in Tkinter callback Traceback (most recent call last): File "/usr/lib/python3.5/tkinter/__init__.py", line 1562, in call return self.func(*args) File "/home/pi/Desktop/pow.py", line 415, in put cur.execute(sql) File "/usr/lib/python3/dist-packages/mysql/connector/cursor.py", line 536, in execute stmt = operation.encode(self._connection.python_charset) AttributeError: 'tuple' object has no attribute 'encode' — Anthony Mendoza
– Anthony Mendoza, Commented Mar 31, 2018 at 4:30

johnII · Accepted Answer · 2018-03-31 04:35:36Z

1

This statement returns a tuple

sql = "SELECT * FROM farm_registration \
       WHERE barangay = %s", (e_barangay);

which you are expecting string instead, so just changed the above into

sql = "SELECT * FROM farm_registration \
       WHERE barangay = %s" % e_barangay;

answered Mar 31, 2018 at 4:35

johnII

1,4431 gold badge14 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Anthony Mendoza Over a year ago

we did that but now we have this error :mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Saguing'' at line 1, my input at baranggay is Saguing

johnII Over a year ago

how about using something like this: sql = "SELECT * FROM farm_registration WHERE barangay = %s" cur.execute(sql, (e_barangay))

Anthony Mendoza Over a year ago

thank you @johnIl but the problem is it should be sql = "SELECT * FROM farm_registration WHERE barangay = '%s'" % e_barangay the '' on %s is missing. but thanks anyway

Collectives™ on Stack Overflow

AttributeError: 'tuple' object has no attribute 'encode' python gui

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related