Python Mysql Request with variables

Question

I have used python for a long time but I have trouble with a particular string-variable manipulation case

I want to do something like this:

##################################

#sample
MYROW= 'ID_project'

result=curs.execute("""select %s FROM shotmanager_projects""",(MYROW))

#result=curs.execute("""select %s FROM shotmanager_projects""",('ID_sample')) 
# don t work too

###################################

And it doesnt work at all!

Why isn't % var not accepted in this case?

Ignacio Vazquez-Abrams · Accepted Answer · 2011-06-13 23:33:41Z

3

(x) is not a tuple with one element, it is a normal value. (x,) is a tuple with one element.

answered Jun 13, 2011 at 23:33

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

Comments

Corey Goldberg · Accepted Answer · 2011-06-13 23:42:23Z

0

result = curs.execute("select %s FROM shotmanager_projects", (MYROW,))

edited Jun 13, 2011 at 23:42

answered Jun 13, 2011 at 23:35

Corey Goldberg

61.4k30 gold badges135 silver badges147 bronze badges

1 Comment

vincseize Over a year ago

Don't Work: MYROW = 'title' result=curs.execute("""select %s FROM shotmanager_projects""",(MYROW)) 'code' return: (('title'),),(('title'),),(('title'),),(('title'),)

Collectives™ on Stack Overflow

Python Mysql Request with variables

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related