pyodbc Too few parameters

Question

cursor.execute("SELECT [Employees].Employee_Name, [Salerys].Salery")
cursor.execute("FROM Employees")
cursor.execute("WHERE (([Employee_Name]="John"));")

cursor.execute("SELECT \[Employees\].Employee_Name, \[Salerys\].Salery")

pyodbc.Error: ('07002', '\[07002\] \[Microsoft\]\[ODBC Microsoft Access Driver\] Too few parameters. Expected 2. (-3010) (SQLExecDirectW)')

Started to use this package since couple of days ago. I want to know how to fix this error & why this error came.

@Chamod_ please make sure you put in the question the exact code you have, because there is no parameter or placeholder in what you've shown, plus that third line will raise a `SyntaxError`. — ljmc, Jan 30 '23 at 11:19
Does this answer your question? [How do I split the definition of a long string over multiple lines?](https://stackoverflow.com/questions/10660435/how-do-i-split-the-definition-of-a-long-string-over-multiple-lines) — June7, Jan 30 '23 at 12:04

score 0 · Answer 1 · answered Feb 20 '23 at 09:05

Please share exact code, that will help understand the problem well. From what you've shared it seems to be syntax issue; please try following, see if it works:

query_filter = 'John'
result = cursor.execute("""
    SELECT [Employees].Employee_Name, [Salerys].Salery
    FROM Employees
    WHERE [Employee_Name]=?
""", query_filter)

pyodbc Too few parameters

1 Answers1