SQLite parameter substitution problem

by

The Cursor.execute() method expects a sequence as second parameter. You are supplying a string which happens to be 8 characters long.

Use the following form instead:

self.cursor.execute("SELECT weight FROM Equipment WHERE name = ?", [item])

Python library reference: sqlite3 Cursor Objects.

More Related Contents:

  1. Importing a CSV file into a sqlite3 database table using Python
  2. How do you escape strings for SQLite table/column names in Python?
  3. How to retrieve inserted id after inserting row in SQLite using Python?
  4. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  5. List of tables, db schema, dump etc using the Python sqlite3 API
  6. Python insert numpy array into sqlite3 database
  7. Python CSV to SQLite
  8. Python sqlite3 and concurrency
  9. What if I don’t close the database connection in Python SQLite
  10. Passing a column name in a SELECT statement in Python
  11. HDF5 – concurrency, compression & I/O performance [closed]
  12. How to get a single result from a SQL query in python?
  13. Parameter unsupported when inserting int
  14. Executing an SQL query over a pandas dataset
  15. “no such table” exception
  16. Is this Python code vulnerable to SQL injection? (SQLite3)
  17. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  18. pysqlite: Placeholder substitution for column or table names?
  19. SQLite not saving data between uses
  20. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  21. Problem with regexp python and sqlite
  22. Python 3 sqlite parameterized SQL-query
  23. Python SQLite3 SQL Injection Vulnerable Code
  24. How to delete a table in SQLAlchemy?
  25. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  26. How to check the existence of a row in SQLite with Python?
  27. sqlite3.OperationalError: no such column – but I’m not asking for a column?
  28. Passing SQLite variables in Python
  29. Python sqlite3 parameterized drop table
  30. Python sqlite3.OperationalError: no such table:

Leave a Comment