Re: Every character of a string becomes a binding

2015-08-22 Thread Johannes Bauer
On 21.08.2015 19:04, Cecil Westerhof wrote: >> Because the execute method expects the bindings to be passed as a >> sequence, > > Yeah, I found that. I solved it a little differently: > urls = c.execute('SELECT URL FROM links WHERE URL = ?', [url]).fetchall() You continuously ask more than am

Re: Every character of a string becomes a binding

2015-08-21 Thread Chris Angelico
On Sat, Aug 22, 2015 at 10:47 AM, Dennis Lee Bieber wrote: > On Fri, 21 Aug 2015 18:39:28 +0200, Cecil Westerhof > declaimed the following: > >>I have the following with sqlite3: >>urls = c.execute('SELECT URL FROM LINKS WHERE URL = ?', url).fetchall() >> > Well, for one complication... Y

Re: Every character of a string becomes a binding

2015-08-21 Thread Cecil Westerhof
On Friday 21 Aug 2015 18:50 CEST, Zachary Ware wrote: > On Fri, Aug 21, 2015 at 11:39 AM, Cecil Westerhof wrote: >> I have the following with sqlite3: urls = c.execute('SELECT URL >> FROM LINKS WHERE URL = ?', url).fetchall() >> >> But this gives: Traceback (most recent call last): File >> "./cre

Re: Every character of a string becomes a binding

2015-08-21 Thread John Gordon
In <871tewppdr@equus.decebal.nl> Cecil Westerhof writes: > I have the following with sqlite3: > urls = c.execute('SELECT URL FROM LINKS WHERE URL = ?', url).fetchall() > But this gives: > Traceback (most recent call last): > File "./createDB.py", line 52, in > urls = c.execute('SELECT

Re: Every character of a string becomes a binding

2015-08-21 Thread Zachary Ware
On Fri, Aug 21, 2015 at 11:39 AM, Cecil Westerhof wrote: > I have the following with sqlite3: > urls = c.execute('SELECT URL FROM LINKS WHERE URL = ?', url).fetchall() > > But this gives: > Traceback (most recent call last): > File "./createDB.py", line 52, in > urls = c.execute('SELECT URL