title: sqlite3 connector in python
body: <p>This doesn't work: I don't get any element.</p>
  
  <p>k0 is float numpy, dk is int:</p>
  
  <pre><code>(k0, dk)
  (&lt;class 'numpy.float64'&gt;, &lt;class 'int'&gt;)
  (20.083143869749225, 6)
  </code></pre>
  
  <p>-</p>
  
  <pre><code>get_close_rods = "select xmid, ymid, angle from datos where  experiment_id=? "
  get_close_rods+= "and file_id=? and ymid between ? and ? and xmid between ? and ? and angle between ? and ? "
  get_close_rods+= "and major/minor between ? and ? order by ((xmid-?)*(xmid-?)+(ymid-?)*(ymid-?))*angle" 
  #get_close_rods+= "order by ((xmid-?)*(xmid-?)+(ymid-?)*(ymid-?))*angle"
  
  args = (str(experiment_id_), str(file_ids[index+1]), str(pos0[1]-dd),
              str(pos0[1]+dd), str(pos0[0]-dd), str(pos0[0]+dd),
              str(angle-dangle), str(angle+dangle), str(k0-dk), str(k0+dk),
              str(pos0[0]), str(pos0[0]), str(pos0[1]), str(pos0[1]))
  
  cursor2.execute(get_close_rods, args)
  </code></pre>
  
  <p><strong>str(k0-dk), str(k0+dk)</strong></p>
  
  <p>It doesn't work either:</p>
  
  <pre><code>get_close_rods = "select xmid, ymid, angle, from datos where  experiment_id=? "
  get_close_rods+= "and file_id=? and ymid between ? and ? and xmid between ? and ? and angle between ? and ? "
  get_close_rods+= "and major/minor between ? and ? order by ((xmid-?)*(xmid-?)+(ymid-?)*(ymid-?))*angle" 
  #get_close_rods+= "order by ((xmid-?)*(xmid-?)+(ymid-?)*(ymid-?))*angle"
  
  args = (str(experiment_id_), str(file_ids[index+1]), str(pos0[1]-dd),
              str(pos0[1]+dd), str(pos0[0]-dd), str(pos0[0]+dd),
              str(angle-dangle), str(angle+dangle), str(15), str(25),
              str(pos0[0]), str(pos0[0]), str(pos0[1]), str(pos0[1]))
  
  cursor2.execute(get_close_rods, args)
  </code></pre>
  
  <p><strong>str(15), str(25)</strong></p>
  
  <p>Doesn't work either if I put <strong>str(float(15)), str(float(25))</strong>.</p>
  
  <p>It doesn't show any error when I use that query.</p>
  
  <p>But this works:</p>
  
  <pre><code>get_close_rods = "select xmid, ymid, angle, from datos where  experiment_id=? "
  get_close_rods+= "and file_id=? and ymid between ? and ? and xmid between ? and ? and angle between ? and ? "
  #get_close_rods+= "and major/minor between ? and ? order by ((xmid-?)*(xmid-?)+(ymid-?)*(ymid-?))*angle" 
  #get_close_rods+= "order by ((xmid-?)*(xmid-?)+(ymid-?)*(ymid-?))*angle"
  get_close_rods+= "and major/minor between 15 and 25 order by ((xmid-?)*(xmid-?)+(ymid-?)*(ymid-?))*angle"
  
  args = (str(experiment_id_), str(file_ids[index+1]), str(pos0[1]-dd),
              str(pos0[1]+dd), str(pos0[0]-dd), str(pos0[0]+dd),
              str(angle-dangle), str(angle+dangle), #str(15), str(25),
              str(pos0[0]), str(pos0[0]), str(pos0[1]), str(pos0[1]))
  
  cursor2.execute(get_close_rods, args) 
  </code></pre>
  
  <p><strong>#str(15), str(25)</strong></p>