Breaking News: Grepper is joining You.com. Read the official announcement!

sqlite3 like python

Lucas Gomes answered on June 26, 2022 Popularity 5/10 Helpfulness 7/10

answer sqlite3 like python

sqlite3 like python

Comment

cur.execute("select * from contacts where name like ?", ('%'+search+'%',))

#Your problem just seems to be that you have supplied a string as the second 
#argument to cur.execute, when you probably meant to supply a single-element tuple 
#containing the string.

#Since a string is a sequence, every character in the string will be interpreted 
#as a separate parameter and that's why you see the "Incorrect number of bindings" 
#error.

Popularity 5/10 Helpfulness 7/10 Language python

Source: stackoverflow.com

Tags: python

Link to this answer
Share Copy Link