Python SQLite multiple question marks query leads to error "row value misused"

Question

The below sample query leads to "row value misused" error. I am just not able to figure out the problem. My intent is to extract all records where "ISIN" matches "Test1" and "Test2".

Environment: Python 3.10.0 Windows 21H1

import sqlite3 as objSQLite

# Connect
objDatabase = objSQLite.connect("Sample.db")
objCursor = objDatabase.cursor()

# Create table
objCursor.execute("create table if not exists ScripData(ISIN text);")

# Add rows
objCursor.execute("insert or ignore into ScripData values(?)", ("Test1", ))
objCursor.execute("insert or ignore into ScripData values(?)", ("Test2", ))
objCursor.execute("insert or ignore into ScripData values(?)", ("Test3", ))
objCursor.execute("insert or ignore into ScripData values(?)", ("Test4", ))

objDatabase.commit()

# Query
objCursor.execute("select * from ScripData where ISIN=(?,?)", ("Test1", "Test2", ))
arrResult = objCursor.fetchall()
print(arrResult)

Error is:

Traceback (most recent call last):
  File "Query.py", line 19, in <module>
    objCursor.execute("select * from ScripData where ISIN=(?,?)", ("Test1", "Test2", ))
sqlite3.OperationalError: row value misused

norie · Accepted Answer · 2021-10-27 01:09:59Z

1

You can't use = to find matches for multiple values, you need to use IN.

objCursor.execute("select * from ScripData where ISIN IN (?,?)", ("Test1", "Test2" ))
arrResult = objCursor.fetchall()

answered Oct 27, 2021 at 1:09

norie

9,9372 gold badges14 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sandeep S D Over a year ago

Thanks! So silly to miss my database basics.

Collectives™ on Stack Overflow

Python SQLite multiple question marks query leads to error "row value misused"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related