title: Prepared Statements and incorrect number of arguments
body: <p>I am using an SQL query to find all the user with a certain RFID value, each user can have multiple RFID values.</p>
  
  <p>I have created a prepared statement, which isn't really required as the value inserted should just be numbers, but, I keep getting the error message saying <code>Incorrect number of arguments executing prepared statement</code> even though I am only entering one value that is stored in a tuple.</p>
  
  <p>The variable RFID is a parameter within the function</p>
  
  <pre><code>conn = Database.connect()  # returns an instance of connector.connect 
  
  cursor = conn.cursor(prepared=True)  # Creates a cursor that is expecting 
  
  sql_query = """SELECT RFID, users.UserID, FirstName, Surname, Email, Dob, Gender, Mobile 
                 FROM users 
                 JOIN RFIDs ON (users.UserID = RFIDs.UserID) 
                 WHERE users.UserID = (SELECT UserID FROM RFIDs WHERE RFID = '%s');"""
  
  cursor.execute(sql_query, (rfid,))  # Get user info
  
  
  user_info_array = cursor.fetch()  # Store the results
  
  
  conn.commit()  # Save the changes to the database
  </code></pre>
  
  <p>The query works fine as I have used it and when manually entering the values in.</p>
  
  <p>Thanks in advance</p>