SQL Update with Variable as parameter error

Question

I'v searched throughout this forum and couldn't find an answer.

cur.execute("UPDATE lastran SET job_date=newtimedate WHERE job_name=usrjobname")

Why is my code now working?

The two variables are newtimedate and usrjobname

is job_name a string/text type? what error do you get? – thaavik Aug 07 '17 at 15:52 — thaavik, Aug 07 '17 at 15:52
what do you expect with "WHERE job_name=job_name"? – Esteban P. Aug 07 '17 at 15:52 — Esteban P., Aug 07 '17 at 15:52
Updated post. The parameter is a variable. – iNeed2LearnToEat Aug 07 '17 at 15:56 — iNeed2LearnToEat, Aug 07 '17 at 15:56
What is the error you are getting? – SS_DBA Aug 07 '17 at 15:57 — SS_DBA, Aug 07 '17 at 15:57

score 1 · Answer 1 · answered Aug 07 '17 at 15:58

I don't know Python, but it seems you're passing your variables as literals... a little Googling tells me this should be it?

cur.execute("UPDATE lastran SET job_date=? WHERE job_name=?", (newtimedate, usrjobname))

1 Answers1