AttributeError: 'tuple' object has no attribute 'encode' - MySQLdb Python

Question

I am writing a Python code with MySQL.

My DB schema is as follows:

-------------
| id | name |
-------------
|    |      |
|    |      |

Following is a part of my code:

cursor = self.conn.cursor()
query = ("SELECT name FROM TABLENAME WHERE id = '%s'", (str(id.decode('unicode_escape').encode('ascii', 'utf-8'),)))
cursor.execute(query)

I am passing the ID from the URL.

And getting the following error:

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

I get the results when I hard-code the valud of ID in the query. But for some reason it is not working when I pass in a parameter.

alecxe · Accepted Answer · 2016-02-11 23:44:16Z

1

The query parameters should be passed as a second parameter to execute():

cursor = self.conn.cursor() 
query = "SELECT name FROM TABLENAME WHERE id = %s"
cursor.execute(query, (str(id.decode('unicode_escape').encode('ascii', 'utf-8')), ))

Note that you don't need the single quotes around the %s placeholder - the database driver would put them automatically if needed depending on the query parameter type.

answered Feb 11, 2016 at 23:44

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

2 Comments

Kreena Mehta Over a year ago

Thanks for your help @alecxe .. The error got resolved.But now it says : 'builtin_function_or_method' object has no attribute 'decode'

alecxe Over a year ago

@KreenaMehta what about just cursor.execute(query, (id, ))?

Collectives™ on Stack Overflow

AttributeError: 'tuple' object has no attribute 'encode' - MySQLdb Python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related