SQLite Forum

ValueError: parameters are of unsupported type
Login
```
Python 3.8.6 (tags/v3.8.6:db45529, Sep 23 2020, 15:52:53) [MSC v.1927 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> db = sqlite3.connect('', isolation_level=None)
>>> setobj = {'a', 'b', 'c', 'd'}
>>> dictobj = {'a': 'b', 'c': 'd'}
>>> db.cursor().execute('select :a, :c', setobj).fetchall()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ValueError: parameters are of unsupported type
>>> db.cursor().execute('select :a, :c', dictobj).fetchall()
[('b', 'd')]
>>>
```