Sqlite3 Python problem with wrong select output

Question

This is my code:

firstName = cursor.execute("SELECT firstName FROM students WHERE id = %s" % idRemove)
print(firstName)

And this is what i get in return:

<sqlite3.Cursor object at 0x00E88C20>

Valwex · Accepted Answer · 2019-03-01 00:41:47Z

1

The function return a cursor object.

print(firstName.fetchone())

answered Mar 1, 2019 at 0:41

Valwex

264 bronze badges

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

2 Comments

Yeah it works thank you! The result is: ('Lord',) But is there a option to remove the brackets and commas?

print(firstName.fetchone()[0])