Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #37346
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!panix!gordon |
|---|---|
| From | John Gordon <gordon@panix.com> |
| Newsgroups | comp.lang.python |
| Subject | Re: Converting a string to a number by using INT (no hash method) |
| Date | Tue, 22 Jan 2013 20:40:39 +0000 (UTC) |
| Organization | PANIX Public Access Internet and UNIX, NYC |
| Lines | 23 |
| Message-ID | <kdmtg7$t4i$1@reader1.panix.com> (permalink) |
| References | <e74ae1aa-f760-4123-8770-3b8a4f9a2f91@googlegroups.com> <mailman.806.1358872054.2939.python-list@python.org> <4339f8d7-2d78-450f-ad0e-91da35615e6d@googlegroups.com> <mailman.812.1358875475.2939.python-list@python.org> <2de57cf7-4a8f-4304-91cf-0024963315d7@googlegroups.com> <mailman.826.1358881376.2939.python-list@python.org> <mailman.829.1358882945.2939.python-list@python.org> |
| NNTP-Posting-Host | panix3.panix.com |
| X-Trace | reader1.panix.com 1358887239 29842 166.84.1.3 (22 Jan 2013 20:40:39 GMT) |
| X-Complaints-To | abuse@panix.com |
| NNTP-Posting-Date | Tue, 22 Jan 2013 20:40:39 +0000 (UTC) |
| User-Agent | nn/6.7.3 |
| Xref | csiph.com comp.lang.python:37346 |
Show key headers only | View raw
In <mailman.829.1358882945.2939.python-list@python.org> Ferrous Cranus <nikos.gr33k@gmail.com> writes:
> May i sent you my code by mail so for you see whats wrong and
> http://superhost.gr produces error?
I tried going to that address and got some error output. I noticed this
in the error dump:
186 if cursor.rowcount == 0:
187 cursor.execute( '''INSERT INTO visitors(pin, host
, hits, useros, browser, date) VALUES(%s, %s, %s, %s, %s)''', (pin, hos
t, 1, useros, browser, date) )
The INSERT statement gives six column names but only five placeholders (%s)
in the VALUES clause.
Perhaps that's the problem?
--
John Gordon A is for Amy, who fell down the stairs
gordon@panix.com B is for Basil, assaulted by bears
-- Edward Gorey, "The Gashlycrumb Tinies"
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 08:15 -0800
RE: Converting a string to a number by using INT (no hash method) "Leonard, Arah" <Arah.Leonard@bruker-axs.com> - 2013-01-22 16:27 +0000
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 09:02 -0800
RE: Converting a string to a number by using INT (no hash method) "Leonard, Arah" <Arah.Leonard@bruker-axs.com> - 2013-01-22 17:24 +0000
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 09:39 -0800
Re: Converting a string to a number by using INT (no hash method) John Gordon <gordon@panix.com> - 2013-01-22 18:36 +0000
Re: Converting a string to a number by using INT (no hash method) Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-01-22 17:22 -0500
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 09:39 -0800
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 10:37 -0800
Re: Converting a string to a number by using INT (no hash method) Michael Torrie <torriem@gmail.com> - 2013-01-22 12:02 -0700
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 11:28 -0800
Re: Converting a string to a number by using INT (no hash method) Alan Spence <alan.spence@ntlworld.com> - 2013-01-22 20:00 +0000
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 11:28 -0800
Re: Converting a string to a number by using INT (no hash method) John Gordon <gordon@panix.com> - 2013-01-22 20:40 +0000
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-23 00:44 -0800
Re: Converting a string to a number by using INT (no hash method) Dave Angel <d@davea.name> - 2013-01-22 14:08 -0500
RE: Converting a string to a number by using INT (no hash method) "Leonard, Arah" <Arah.Leonard@bruker-axs.com> - 2013-01-22 20:30 +0000
Re: Converting a string to a number by using INT (no hash method) Dave Angel <d@davea.name> - 2013-01-22 15:43 -0500
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 10:37 -0800
Re: Converting a string to a number by using INT (no hash method) Ferrous Cranus <nikos.gr33k@gmail.com> - 2013-01-22 09:02 -0800
Re: Converting a string to a number by using INT (no hash method) Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-01-22 16:27 +0000
Re: Converting a string to a number by using INT (no hash method) Dave Angel <d@davea.name> - 2013-01-22 11:40 -0500
Re: Converting a string to a number by using INT (no hash method) alex23 <wuwei23@gmail.com> - 2013-01-22 17:32 -0800
Re: Converting a string to a number by using INT (no hash method) Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-01-23 03:02 +0000
Re: Converting a string to a number by using INT (no hash method) alex23 <wuwei23@gmail.com> - 2013-01-22 19:59 -0800
Re: Converting a string to a number by using INT (no hash method) "D'Arcy J.M. Cain" <darcy@druid.net> - 2013-01-22 12:04 -0500
csiph-web