Error while getting data out of sqlite3 database with python3

Asked Apr 14 '17 at 12:10

Active Apr 14 '17 at 12:10

Viewed 40 times

I'm trying to get data out of a sqlite database but I'm getting an error.

Code:

self.con = sqlite3.connect("config.db")
self.cur = self.con.cursor()
self.cur.execute("CREATE TABLE IF NOT EXISTS config (PCFolder TEXT, ServerFolder TEXT)")
self.con.commit()
dpop = input("Dir path on the PC->") #dpop means "dir path on pc"
dpos = input("Dir path on the server->")
self.cur.execute("INSERT INTO config VALUES (?, ?)", (dpop, dpos))
self.con.commit()
self.cur.execute("SELECT * FROM config WHERE PCFolder=?", (dpop))
name = cur.fetchall()
print(name)

Terminal

self.cur.execute("SELECT * FROM config WHERE PCFolder=?", (dpop))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The 
current statement uses 1, and there are 11 supplied.

asked Apr 14 '17 at 12:10

Soloritur

5

You need to pass the single parameter as a tuple e.g. `(dpop,)` with the extra comma. Currently it's taking your string and breaking it down into a sequence of 11 characters rather than treating it as a single string. – roganjosh Apr 14 '17 at 12:13
@roganjosh works, thank you – Soloritur Apr 14 '17 at 12:23
1

Indeed I found it really hard to find a good title.. – Soloritur Apr 14 '17 at 12:30
Searching for the exception is always a good start. 1st match in this case: http://stackoverflow.com/questions/16856647/sqlite3-programmingerror-incorrect-number-of-bindings-supplied-the-current-sta – Ilja Everilä Apr 14 '17 at 12:37
Oh sorry, next time – Soloritur Apr 14 '17 at 12:51

Error while getting data out of sqlite3 database with python3

0 Answers0