title: SQLite parameter substitution and quotes
body: <p>I have this line that works OK:</p>
  
  <pre><code>c.execute('select cleanseq from cleanseqs WHERE newID="%s"'%name)
  </code></pre>
  
  <p>But I want to use SQLite parameter substitution instead instead of string substitution (because I see <a href="http://docs.python.org/library/sqlite3.html" rel="noreferrer">here</a> that this is safer).</p>
  
  <p>This is my (failed) try:</p>
  
  <pre><code>t = (name,)
  c.execute('select cleanseq from cleanseqs WHERE newID="?"',t)
  </code></pre>
  
  <p>But this line returns:</p>
  
  <blockquote>
    <p>'Incorrect number of bindings
    supplied. The current statement uses
    0, and there are 1 supplied.'</p>
  </blockquote>
  
  <p>So the left part of my statement doesn't work. I am supplying one binding (name, in t) but seems that the question mark (?) is not being parsed. If I delete the quotes sourronding the ?, it works. But I want the quotes to remain there since I remember that there are cases where I need them.</p>
  
  <p>So the question is: How do I convert this line:</p>
  
  <pre><code>c.execute('select cleanseq from cleanseqs WHERE newID="%s"'%name)
  </code></pre>