pyodbc the sql contains 0 parameter markers but 1 parameters were supplied’ ‘hy000’

by

Parameters in an SQL statement via ODBC are positional, and marked by a ?. Thus:

# SQL with parameters start
res = cursor.execute('''
SELECT * FROM TABLE 
WHERE TABLE.TIMESTAMP BETWEEN ? AND ?
''', STARTDATE, ENDDATE)
# SQL with parameters stop

Plus, it’s better to avoid passing dates as strings. Let pyodbc take care of that using Python’s datetime:

from datetime import datetime
...
STARTDATE = datetime(year=2017, month=3, day=1)
ENDDATE = datetime(year=2017, month=3, day=1, hour=0, minute=0, second=1)

then just pass the parameters as above. If you prefer string parsing, see this answer.

More Related Contents:

  1. PYODBC–Data source name not found and no default driver specified
  2. pyodbc – How to perform a select statement using a variable for a parameter
  3. Get data from pandas into a SQL server with PYODBC
  4. pyodbc insert into sql
  5. How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
  6. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  7. Remote connection to MS SQL – Error using pyodbc vs success using SQL Server Management Studio
  8. SQL / Pandas equivalent
  9. Pandas read_sql with parameters
  10. Pandas DENSE RANK
  11. How to create a large pandas dataframe from an sql query without running out of memory?
  12. Passing table name as a parameter in psycopg2
  13. Getting the SQL from a Django QuerySet [duplicate]
  14. How can I get dict from sqlite query?
  15. Using a WHERE ___ IN ___ statement
  16. Django: Adding “NULLS LAST” to query
  17. return SQL table as JSON in python
  18. Output pyodbc cursor results as python dictionary
  19. LEFT JOIN Django ORM
  20. Unable to install pyodbc on Linux
  21. Python, SQLAlchemy pass parameters in connection.execute
  22. How to see the raw SQL queries Django is running?
  23. How to log all sql queries in Django?
  24. Python String Formats with SQL Wildcards and LIKE
  25. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  26. SQL join or R’s merge() function in NumPy?
  27. In Python, Using pyodbc, How Do You Perform Transactions?
  28. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  29. How to delete a record in Django models?
  30. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()

Leave a Comment