Jan-21-2018, 01:12 AM
Hi everyone, Im just learning how use the SQlite3 and everything seems
pretty straight forward, but I'm having trouble getting it to SELECT from a given user input.
This creates the database fine:
pretty straight forward, but I'm having trouble getting it to SELECT from a given user input.
This creates the database fine:
conn = sqlite3.connect('SVM_PROJECTS.db') c = conn.cursor() c.execute('CREATE TABLE IF NOT EXISTS Project_Info (ProjectNumber TEXT, ProjectName TEXT, ProjectAddress TEXT)') c.execute("INSERT INTO Project_Info(ProjectNumber, ProjectName, ProjectAddress) VALUES(?,?,?)", (Project_Number, Project_Name, Project_Address)) conn.commit()But this is were I would like a user to enter a Project Number and pull the row from the database.
import sqlite3 Number = input("What is the Project Number") conn = sqlite3.connect('SVM_PROJECTS.db') c = conn.cursor() c.execute('SELECT * FROM Project_Info WHERE ProjectNumber=?',(Number)) for row in c.fetchall(): Project_Name = row[1]
Error:Traceback (most recent call last):
File "/Users/barnettchenault/Desktop/test - AVA sqlite read.py", line 8, in <module>
c.execute('SELECT * FROM Project_Info WHERE ProjectNumber=?',(Number))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.
Im sure its just in the formatting I just can't find the correct arrangement.