title: Incorrect syntax near 's' in pyodbc
body: <p>Sometimes I get this error randomly when I try to insert data in to the database. I fetch the data with using request.get and parsing the JSON data.</p>
  
  <p>This is the error that I get:</p>
  
  <blockquote>
    <p>pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17
    for SQL Server][SQL Server]Incorrect syntax near 's'. (102)
    (SQLExecDirectW); [42000] [Microsoft][ODBC Driver 17 for SQL
    Server][SQL Server]Unclosed quotation mark after the character string
    ')'. (105)")</p>
  </blockquote>
  
  <p>This is my code:</p>
  
  <pre><code>for product in parsed['products']:
                  cursor.execute("INSERT INTO dbo.producten (productid, datum_toegevoegd, naam, prijs_excl, prijs_incl, gewicht) VALUES ('%s','%s','%s','%s','%s','%s')" %(product['id'],product['created_at'], product['nl']['title'],product['price_excl'],product['price_incl'],product['weight']))
  </code></pre>