what is wrong with my code

[53535]

import sqlite3
id1 = input('Enter the book id: ')
conn = sqlite3.connect("KJV+.SQLite3")
c = conn.cursor()
c.execute("select * from verses where book_number = ? and chapter = 1 and verse = 1" %  id1)
text = c.fetchmany(1)
print(text)
                   

error:

Error:
c.execute("select * from verses where book_number = ? and chapter = 1 and verse = 1" %  id1)
TypeError: not all arguments converted during string formatting

[ibreeden]

Test the line in the Python console.

>>> id1 = "Hello"
>>> print("select * from verses where book_number = ? and chapter = 1 and verse = 1" % id1)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
TypeError: not all arguments converted during string formatting
>>>
>>> # Use the right syntax.
>>> print("select * from verses where book_number = %s and chapter = 1 and verse = 1" % id1)
select * from verses where book_number = Hello and chapter = 1 and verse = 1
>>>
>>> # Still not correct if id1 is a string.
>>> print("select * from verses where book_number = '%s' and chapter = 1 and verse = 1" % id1)
select * from verses where book_number = 'Hello' and chapter = 1 and verse = 1
>>>
>>> # Or use the modern f-string.
>>> print(f"select * from verses where book_number = '{id1}' and chapter = 1 and verse = 1")
select * from verses where book_number = 'Hello' and chapter = 1 and verse = 1
>>> 
>>> But the advised method for Sqlite3 is this:
>>> c.execute("select * from verses where book_number = ? and chapter = 1 and verse = 1", (id1,))

[53535]

solved by this

import sqlite3



id1 = input('Enter the book id: ')
c = input('Enter the chapter: ')
p = input('Enter the position: ')


conn = sqlite3.connect("KJV+.SQLite3")
c = conn.cursor()

c.execute("select * from verses where book_number = ? and chapter = 1 and verse = 1",(id1,))

text = c.fetchmany(1)
print(text)

but when i try too add more arguments , error happens

import sqlite3



id1 = input('Enter the book id: ')
c = input('Enter the chapter: ')
p = input('Enter the position: ')


conn = sqlite3.connect("KJV+.SQLite3")
c = conn.cursor()

c.execute("select * from verses where book_number = ? and chapter = ? and verse = ?",(id1,c,p))

text = c.fetchmany(1)
print(text)

Error:
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 3 supplied.

Yoriz write Apr-07-2022, 11:51 AM:
Please post errors (In their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[ibreeden]

You are using the variable "c" for different things:

c = input('Enter the chapter: ')
...
c = conn.cursor()

This does not explain the error message, but you should repair this first.

Also: when an error occurs, please show the complete error message.

[53535]

what you said is right, problem solved, thanks