Python MySQLdb SELECT not returning proper value

Question

Here's the code I'm working on:

poljeID = int(cursor.execute("SELECT poljeID FROM stanje"))
xkoord = cursor.execute("SELECT xkoord FROM polje WHERE poljeID = %s;", poljeID)
ykoord = cursor.execute("SELECT ykoord FROM polje WHERE poljeID = %s;", poljeID)

print xkoord, ykoord

It's a snippet from it, basically what it needs to do is fetch the ID of the field (poljeID) where an agent is currently on (stanje) and use it to get the x and y coordinates of that field (xkoord, ykoord).

The initial values for the variables are:

poljeID = 1
xkoord = 0
ykoord = 0

The values that I get with that code are:

poljeID = 1
xkoord = 1
ykoord = 1

What am I doing wrong?

You should't do database work in your application. Use SELECT xkoord, ykoord FROM polje WHERE poljeID IN (SELECT poljeID FROM stanje). — Matthias
– Matthias, Commented Feb 25, 2014 at 16:02

Daniel Roseman · Accepted Answer · 2014-02-25 15:59:31Z

1

cursor.execute does not return the result of the query, it returns the number of rows affected. To get the result, you need to do cursor.fetchone() (or cursor.fetchall()) for each query.

(Note, really the second and third queries should be done at once: SELECT xkoord, ycoord FROM ...)

answered Feb 25, 2014 at 15:59

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vedran Karačić Over a year ago

Changed it to cursor.execute("SELECT xkoord, ykoord FROM polje WHERE poljeID = %s;", poljeID) xkoord, ykoord = cursor.fetchone() and it works now. Thanks!

Collectives™ on Stack Overflow

Python MySQLdb SELECT not returning proper value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related