title: ProgrammingErrorL(The SQL contains 0 parameter markers, but 1 parameter were supplied, 'HY000')
body: <p>I'm passing data to database for querying the database but I have run into following error.</p>
  
  <pre><code> &gt;&gt;&gt; my_cursor.execute(my_query,  var1)
   Traceback (most recent call last):
     File "&lt;stdin&gt;", line 1, in &lt;module&gt;
   pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 1 parameters were supplied', 'HY000')
  </code></pre>
  
  <p>my codes are </p>
  
  <pre><code>  import pyodbc
    import pandas as pd
  
    var1 = 'UCSB'
    my_connection = pyodbc.connect('DSN=MapR-64-Hive', autocommit=True)
    my_cursor = my_connection.cursor()
    my_query =  """
        select *  from polaris_datasets.snmaster  where parent_pid rlike '%s' and created_date &gt;=  "2017-12-01 00:00:00"
        """ 
  
    my_cursor.execute(my_query,  var1)
  </code></pre>
  
  <p>Does anyone know what would cause this issue?</p>