Syntax error in query expression, SQL via PYODBC

Question

The exact error message is:

ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'occupied = False, electric = False, family = False, disabled = False'. (-3100) (SQLExecDirectW)")

I've looked everywhere I can see but don't understand what I'm doing wrong, the line in question is as follows:

spacelist = cursor.execute("SELECT space, distance1, distance2, distance3, distance4, distance5 FROM spaces WHERE occupied = False, electric = True")

Try: WHERE occupied = False AND electric = True

June7
– June7

2022-05-11 13:14:56 +00:00
Commented May 11, 2022 at 13:14 — June7
– June7, Commented May 11, 2022 at 13:14
The WHERE clause is wrong

Panagiotis Kanavos
– Panagiotis Kanavos

2022-05-11 13:17:39 +00:00
Commented May 11, 2022 at 13:17 — Panagiotis Kanavos
– Panagiotis Kanavos, Commented May 11, 2022 at 13:17

Amine Ben Khelifa · Accepted Answer · 2022-05-11 13:22:21Z

2

Try this :

spacelist = cursor.execute("SELECT space, distance1, distance2, distance3, 
distance4, distance5 FROM spaces WHERE occupied = False AND electric = True")

answered May 11, 2022 at 13:22

Amine Ben Khelifa

7656 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Syntax error in query expression, SQL via PYODBC

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related