c.execute("SELECT bin FROM bins WHERE qtl LIKE '%:keys%'",{'keys':keywords})This query returns empty. When it is executed, keywords = 'harvest'. To check it, I do it on the command line and it works as expected: sqlite> SELECT bin FROM bins WHERE qtl LIKE '%harvest%'; 11C 11D 12F I guess there is a problem with the "%". -- http://mail.python.org/mailman/listinfo/python-list
