Jul-25-2022, 03:23 PM
(Jul-25-2022, 05:00 AM)deanhystad Wrote: Why are you using quotes inside your queries?
I expect a query to be formatted like this:
result = self.cursor.execute("SELECT money FROM users WHERE user_id = ?", (user_id,)).fetchmany(1)I guess you can make a table where all the columns have starting and ending quotes, but why?
And why are you using fetchmany(1) instead fetchone()?
return self.cursor.execute("SELECT money FROM users WHERE user_id = ?", (user_id,)).fetchone()
Thanks, it was all about the quotes that were in the db.py file.