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()
>>
> Well, for one complication... You are asking for the very information
> you are providing...
>
> select URL field
> where the URL field is equal to some value.
>
> What do you really expect from that? If the table has multiple records
> with the same URL value, you will get multiple copies of the same URL.
More likely, it's a simple question: "Do you have this URL in your
links?". If you get back a single row, the answer is yes; if you get
back no rows, the answer is no.
ChrisA
--
https://mail.python.org/mailman/listinfo/python-list
