Re: problem with sqlite3: cannot use < in a SQL query with (?)

[Tim Chase]

On 2014-01-23 03:32, lgabiot wrote:
>  >>>cursor = conn.execute("SELECT filename, filepath  FROM files
>  >>>WHERE   
> max_level<(?)", threshold)
> that doesn't work (throw an exception)

That last argument should be a tuple, so unless "threshold"
 is a tuple, you would want to make it

  sql = "SELECT ... WHERE max_level < ?"
  cursor = conn.execute(sql, (threshold,))

-tkc



-- 
https://mail.python.org/mailman/listinfo/python-list