title: Syntax for a parameter query in Python (pyodbc)
body: <p>I am trying to write results of some processing into SQL Server table.
  My results are store in a list of lists where each item of the list is a list. I am using parameters (6 params) and I am getting the following error:</p>
  
  <p>cnxn.execute(sqlStatement, (item[0],item[1],item[2],item[3],item[4],item[5]))
  pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 6 parameters were supplied', 'HY000')</p>
  
  <p>That's my code</p>
  
  <pre><code>sqlStatement = "INSERT INTO CEA_CR (`SessionID`, `Session.Call_TYPE_Assigned`, `Session.Did_Call_Type_happen_on_this_call`, `Session.Was_there_a_system_or_Rep_generated_Memo_that_matches_with_Call_Type` , 'cycle' , 'version')  VALUES (%s, %s, %s, %s ,%s ,%s)"
  
  for item in result:
       wr.writerow(item)
       cnxn.execute(sqlStatement, (item[0],item[1],item[2],item[3],item[4],item[5]))
       cnxn.commit()
  </code></pre>
  
  <p>Anyone knows why my execution fails ?</p>