On Wed, Feb 24, 2010 at 3:41 PM, Dennis Lee Bieber
wrote:
> No there isn't... The problem is that you need to put the wildcards
> into the parameter instead of the placeholder.
Thank you, it works now.
Best,
SB
--
http://mail.python.org/mailman/listinfo/python-list
Am 24.02.10 18:07, schrieb Sebastian Bassi:
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 qt
On Feb 24, 5:21 pm, Jon Clements wrote:
> On Feb 24, 5:07 pm, Sebastian Bassi wrote:
>
> > 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 wo
On Feb 24, 5:07 pm, Sebastian Bassi wrote:
> 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 W
