Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #95542

Re: Every character of a string becomes a binding

Show all headers | View raw

On Sat, Aug 22, 2015 at 10:47 AM, Dennis Lee Bieber
<wlfraed@ix.netcom.com> wrote:
> On Fri, 21 Aug 2015 18:39:28 +0200, Cecil Westerhof <Cecil@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

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Every character of a string becomes a binding Cecil Westerhof <Cecil@decebal.nl> - 2015-08-21 18:39 +0200
  Re: Every character of a string becomes a binding Zachary Ware <zachary.ware+pylist@gmail.com> - 2015-08-21 11:50 -0500
    Re: Every character of a string becomes a binding Cecil Westerhof <Cecil@decebal.nl> - 2015-08-21 19:04 +0200
      Re: Every character of a string becomes a binding Johannes Bauer <dfnsonfsduifb@gmx.de> - 2015-08-22 11:45 +0200
  Re: Every character of a string becomes a binding John Gordon <gordon@panix.com> - 2015-08-21 17:02 +0000
  Re: Every character of a string becomes a binding Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2015-08-21 20:47 -0400
  Re: Every character of a string becomes a binding Chris Angelico <rosuav@gmail.com> - 2015-08-22 11:03 +1000

csiph-web