Python Forum

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:

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.

which version of python are you running?
In python 3, (or 2.7 with proper setup), you can do the followning

sql_cmd = 'SELECT * FROM Project_Info WHERE ProjectNumber={}'.format(Number)
c.execute(sql_cmd)

(Jan-21-2018, 01:36 AM)Larz60+ Wrote: [ -> ]sql_cmd = 'SELECT * FROM Project_Info WHERE ProjectNumber={}'.format(Number)
c.execute(sql_cmd)

Lars, Im running Python 3. When I run that revision I seem to be missing something.
as there is no error but it doesn't return anything

import sqlite3

Number = input("What is the Project Number")

conn = sqlite3.connect('SVM_PROJECTS.db')
c = conn.cursor()

sql_cmd = 'SELECT * FROM Project_Info WHERE ProjectNumber={}'.format(Number)
c.execute(sql_cmd)
for row in c.fetchall():
    Project_Number = row[0]
    Project_Name = row[1]
    print(Project_Name)

---

Larz -

Nevermind I figured it out I needed an extra set of quotations around the brackets.

sql_cmd = "SELECT * FROM Project_Info WHERE ProjectNumber='{}'".format(Number)

Perhaps your database is not ok.
do you know how to use sqlite3 from command line?