how to use variables when open a sqlite database?

[53535]

this is my code

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

import sqlite3   conn = sqlite3.connect("KJV+.SQLite3") c = conn.cursor()     while True:     b_id = input('Enter the book id: ')     c = input('Enter the chapter: ')     p = input('Enter the position: ')     c.execute("select * from verses where book_number = [b_id] and chapter = [c] and verse = [p]")     text = c.fetchmany(1)     print(text)                             break

Yoriz write Apr-07-2022, 11:54 AM:
Reverted back to the previous edit that had code in it

Larz60+ write Apr-07-2022, 09:02 AM:
Please post all code, output and errors (it it's 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.
Fixed for you this time. Please use BBCode tags on future posts.

[ndc85430]

Have you looked at the documentation? It does tell you how to parameterise a query.