title: Pythons Bottle with SQLITE3
body: <p>I have been trying to practise Bottle Py. There is a tutorial about making an APP: TODO.</p>
  
  <p>It works fine. But If task id exceeds 1 character that means 10 instead of 1,2,3,4,5,6,7,8,9</p>
  
  <p>It shows error like below.</p>
  
  <blockquote>
    <p>ProgrammingError('Incorrect number of bindings supplied. The current
    statement uses 1, and there are 2 supplied.',)</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/FN9pN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FN9pN.png" alt="enter image description here"></a></p>
  
  <p>Code is:</p>
  
  <pre><code>@route('/edit/&lt;no:int&gt;', method='GET')
  def edit_item(no):
  
      if request.GET.save:
          edit = request.GET.task.strip()
          status = request.GET.status.strip()
  
          if status == 'open':
              status = 1
          else:
              status = 0
  
          conn = sqlite3.connect('todo.db')
          c = conn.cursor()
          c.execute("UPDATE todo SET task = ?, status = ? WHERE id LIKE ?", (edit, status, no))
          conn.commit()
  
          return '&lt;p&gt;The item number %s was successfully updated&lt;/p&gt;' % no
      else:
          conn = sqlite3.connect('todo.db')
          c = conn.cursor()
          c.execute("SELECT task FROM todo WHERE id LIKE ?", (str(no)))
          cur_data = c.fetchone()
  
          return template('edit_task', old=cur_data, no=no)
  </code></pre>
  
  <p>Tracebacks:</p>
  
  <p>1.</p>
  
  <pre><code>Traceback (most recent call last):
    File "/usr/lib/python2.7/dist-packages/bottle.py", line 862, in _handle
      return route.call(**args)
    File "/usr/lib/python2.7/dist-packages/bottle.py", line 1737, in wrapper
      rv = callback(*a, **ka)
    File "todo.py", line 67, in edit_item
      c.execute('SELECT task FROM todo WHERE id LIKE ?', no)
  ValueError: parameters are of unsupported type
  </code></pre>
  
  <p><strong>2.</strong></p>
  
  <pre><code>Traceback (most recent call last):
    File "/usr/lib/python2.7/dist-packages/bottle.py", line 862, in _handle
      return route.call(**args)
    File "/usr/lib/python2.7/dist-packages/bottle.py", line 1737, in wrapper
      rv = callback(*a, **ka)
    File "todo.py", line 67, in edit_item
      c.execute('SELECT task FROM todo WHERE id LIKE ?', (no))
  ValueError: parameters are of unsupported type
  </code></pre>
  
  <p>What to do?</p>