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

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 ce...@decebal.nl 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 module urls =

Every character of a string becomes a binding

2015-08-21 Thread Cecil Westerhof
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 module urls = c.execute('SELECT URL FROM LINKS WHERE URL = ?', url).fetchall()

Re: Every character of a string becomes a binding

2015-08-21 Thread John Gordon
In 871tewppdr@equus.decebal.nl Cecil Westerhof ce...@decebal.nl 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 module urls =

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 ce...@decebal.nl 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

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 wlfr...@ix.netcom.com wrote: On Fri, 21 Aug 2015 18:39:28 +0200, Cecil Westerhof ce...@decebal.nl declaimed the following: I have the following with sqlite3: urls = c.execute('SELECT URL FROM LINKS WHERE URL = ?', url).fetchall()