Python Forum
error in python and mysql statement
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
error in python and mysql statement
#2
I updated the SQL Statement it complains on %s. If I hard code the value 2 it works?

SELECT usertimein FROM userstimeclock WHERE userid = %s AND usertimeout IS NULL ORDER BY timeclockid DESC LIMIT 1
Reply


Messages In This Thread
error in python and mysql statement - by vj78 - Apr-07-2021, 10:15 PM
RE: error in python and mysql statement - by vj78 - Apr-07-2021, 10:31 PM
RE: error in python and mysql statement - by buran - Apr-08-2021, 05:26 AM
RE: error in python and mysql statement - by vj78 - Apr-08-2021, 01:29 PM
RE: error in python and mysql statement - by vj78 - Apr-08-2021, 02:08 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python and MYSQL Resultset vj78 2 2,266 Apr-02-2021, 12:41 AM
Last Post: vj78
  error when inserting list statement from python to MySQL ADBYITMS 0 1,544 Nov-10-2019, 10:44 AM
Last Post: ADBYITMS
  mysql database error brecht83 1 4,972 Dec-14-2018, 01:25 PM
Last Post: jeanMichelBain

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020