jeudi 26 mars 2015

Programming error with SQlite3

i am getting the below errors



Traceback (most recent call last):
File "D:\PYTHON SUPER INP\DB test - Copy1220.py", line 29, in <module>
if __name__ == "__main__":main()
File "D:\PYTHON SUPER INP\DB test - Copy1220.py", line 17, in main
addCust("Zach")
File "D:\PYTHON SUPER INP\DB test - Copy1220.py", line 13, in addCust
VALUES(?)""",(name))
ProgrammingError: Incorrect number of bindings supplied. The current
statement uses 1, and there are 4 supplied.


with my follwing code



import sqlite3

createDb = sqlite3.connect(":memory:")
queryCurs = createDb.cursor()

def createTable():
queryCurs.execute(''' CREATE TABLE customers
(id INTEGER PRIMARY KEY, name TEXT)''')

def addCust(name):
queryCurs.execute("""INSERT INTO customers (name)
VALUES(?)""",(name))

def main():
createTable()
addCust("Zach")
createDb.commit()

queryCurs.execute("SELECT * FROM customers")

for i in queryCurs:
print "/n"
for j in i:
print j

queryCurs.close

if __name__ == "__main__":main()

Aucun commentaire:

Enregistrer un commentaire