How to display information from database sqlite3 using GUI Tkinter in Python in a specific format?

Question

I am trying to retrieve information from the database and display it in this certain way:

Name: Batman

Price: £ 18

But I am getting this error: "TypeError: 'int' object is not subscriptable."

How can I fix that?

c.execute("SELECT name, price FROM products WHERE id=02")
    records = c.fetchone()
    # print(records)

    print_products = ''
    for record in records:
        print_products += 'Name:' + str(record[0]) + '\n' + 'Price: £' + str(record[1])

    query_label = Label(frame, fg='darkblue', bg='darkgray', text=print_products)
    query_label.pack()

acw1668 · Accepted Answer · 2021-01-28 01:11:39Z

2

Since you only fetch one record from the result, records is a tuple of column values. Then you use for record in records:, it means record is a column value that may be an integer. So using record[0] will raise the mentioned exception.

Actually you don't need the for loop at all:

c.execute("SELECT name, price FROM products WHERE id=02")
record = c.fetchone()

# check whether record exists
if record:
    print_products = 'Name:' + str(record[0]) + '\n' + 'Price: £' + str(record[1])

    query_label = Label(frame, fg='darkblue', bg='darkgray', text=print_products)
    query_label.pack()

answered Jan 28, 2021 at 1:11

acw1668

48k5 gold badges30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to display information from database sqlite3 using GUI Tkinter in Python in a specific format?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related