On 10/5/13 10:30 AM, Νίκος Αλεξόπουλος wrote:
Στις 5/10/2013 5:28 μμ, ο/η Chris Angelico έγραψε:
On Sun, Oct 6, 2013 at 12:24 AM, Νίκος Αλεξόπουλος
<nikos.gr...@gmail.com> wrote:
But i have given you the line that produces the error:

The statement you quoted is an INSERT. The traceback quotes a SELECT.
These are not the same line of code. You still have not shown us the
actual line from the traceback.

ChrisA

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


Nikos, slow down. Don't post three emails before someone has a chance to respond.

To get help, you have to show the code that goes along with the traceback. Your subject line even says, "select fails", so you know it is a select statement in the traceback. You have to show us *that code*, and more than one line. You've shown the line here, but we don't know what cID and cookieID are, so we can't help yet.

Saying "every mysql statement that involves cookieID fails" isn't enough. Show us the code containing the line that actually is failing in that traceback. Include enough of the code that we can figure out what is going on.

You've said that you can do better here.  Please try to.

--Ned.
--
https://mail.python.org/mailman/listinfo/python-list

Reply via email to