How to Fix 'TypeError: Not All Arguments Converted During String Formatting' in Parameterized SQL Queries?

Parameterized SQL Queries: Resolving "TypeError: Not All Arguments Converted During String Formatting"

In parameterized SQL queries, it's crucial to ensure proper syntax and data conversion to avoid errors. When attempting to use string formatting in a parameterized query, the error "TypeError: not all arguments converted during string formatting" can arise.

To resolve this issue, avoid using %s as a placeholder for arguments. Instead, pass the arguments as a separate list to the execute() method. For example:

import MySQLdb as mdb

class Test:
    def check(self, search):
        con = mdb.connect(...)
        cur = con.cursor()
        cur.execute("SELECT * FROM records WHERE email LIKE %s", [search])
        ...

By passing search in a list, you explicitly indicate that it should be treated as a separate argument for conversion and inclusion in the query. This approach ensures that all arguments are properly converted and used in the query.

The above is the detailed content of How to Fix 'TypeError: Not All Arguments Converted During String Formatting' in Parameterized SQL Queries?. For more information, please follow other related articles on the PHP Chinese website!