Apr-07-2022, 10:30 AM
(This post was last modified: Apr-07-2022, 11:49 AM by Yoriz.
Edit Reason: Added error tags
)
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