steave posted

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current sta tement uses 1, and there are 2 supplied.


pageval=("82")
insertstmtpage = "insert into pages values(?)"
c.execute(insertstmtpage,pageval)

it giving me error like

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current sta tement uses 1, and there are 2 supplied.

but i think i supplied proper value which is text and i supplied one value to current statement . and it saying you supplied which is wrong .

so not sure what is wrong ?

Edit Question

steave ray
answered Nov 30 '-1 00:00


pageval=("82",)
insertstmtpage = "insert into pages values(?)"
c.execute(insertstmtpage,pageval)

pass the comma after the value .

Edit Answer

steave posted

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current sta tement uses 1, and there are 2 supplied.

steave ray answered Nov 30 '-1 00:00

Latest Questions

Insert link

Insert image

steave ray
answered Nov 30 '-1 00:00