Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Date: Sat, 5 Oct 2013 11:44:18 -0300
From: Zero Piraeus <z@etiol.net>
To: python-list@python.org
Subject: Re: Select fails when cookie tried to get a numeric value
References: <l2p4o4$4ht$1@dont-email.me> <mailman.744.1380981591.18130.python-list@python.org> <l2p7ef$j06$1@dont-email.me> <mailman.745.1380983299.18130.python-list@python.org> <l2p7qr$j06$3@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <l2p7qr$j06$3@dont-email.me>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.752.1380991203.18130.python-list@python.org>
Lines: 29
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:56205

:

On Sat, Oct 05, 2013 at 05:30:53PM +0300, Νίκος Αλεξόπουλος wrote:
> Every mysql statemtns that involved cookieID fails.
> 
> in this example this:
> 
> # find the visitor record for the (saved) cID and current host
> cur.execute('''SELECT * FROM visitors WHERE counterID = %s and
> cookieID = %s''', (cID, cookieID) )
> data = cur.fetchone()        #cookieID is unique

If every cur.execute() invocation that you try to pass cookieID to
fails, that suggests you can't pass cookieID to cur.execute() ...
perhaps because it's the wrong type.

The use of '%s' string interpolation suggests that cur.execute() is
expecting a string. Is cookieID a string? If not, is it some kind of
object that contains a string value within it? Maybe it has some kind of
attribute you could pass, like cookieID.value or similar?

That may or may not be correct, but it's the kind of mental process you
should be going through to solve your problem.

 -[]z.

-- 
Zero Piraeus: inter caetera
http://etiol.net/pubkey.asc