Python sqlite3 string variable in execute

by

Parameter markers can be used only for expressions, i.e., values.
You cannot use them for identifiers like table and column names.

Use this:

cur.execute("SELECT "+column+" FROM Data where "+goal+"=?", (constrain,))

or this:

cur.execute("SELECT %s FROM Data where %s=?" % (column, goal), (constrain,))

(And don’t commit before you have actually finished accessing the data.)

More Related Contents:

  1. Variable table name in sqlite
  2. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  3. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  4. Django: Deploying an application on Heroku with sqlite3 as the database
  5. How do you escape strings for SQLite table/column names in Python?
  6. How to load existing db file to memory in Python sqlite3?
  7. Sqlite insert query not working with python?
  8. Python SQLite parameter substitution with wildcards in LIKE
  9. Inserting a table name into a query gives sqlite3.OperationalError: near “?”: syntax error
  10. How can I get dict from sqlite query?
  11. Using a WHERE ___ IN ___ statement
  12. Python insert numpy array into sqlite3 database
  13. parameter unsupported when inserting int in sqlite
  14. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  15. SQLite parameter substitution and quotes
  16. Python SQLite: database is locked
  17. How to discover table properties from SQLAlchemy mapped object
  18. String similarity with Python + Sqlite (Levenshtein distance / edit distance)
  19. Auto Increment on Composite Primary Key – Sqlite3 + Python
  20. Is there a way to get a list of column names in sqlite?
  21. Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
  22. How to upgrade sqlite 3.8.2 to >= 3.8.3
  23. creating a database outside the application context
  24. sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings
  25. How to delete a table in SQLAlchemy?
  26. Python and SQLite: insert into table
  27. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  28. How to check the existence of a row in SQLite with Python?
  29. sqlite3.OperationalError: no such column – but I’m not asking for a column?
  30. Django: sudden DB reset after Heroku sleep

Leave a Comment