How to specify a string value from a returned database returned tuple

Question

When running the following code I would like to be able to store the returned values in a variable as a string. However when I run the code it will return the first name from the database in this format

[(u'Kiefer',)]

What would I need to change in order to just return a clean string? I was thinking I could use strip although I have never used it on a tuple (not even sure if you can) but I was hoping there is a more elegant way. Also I am using the sqlite3 module.

def search_db(self,ID,FName,LName):
    #try:
    FName +='%'
    LName += '%'
    self.cur.execute(("""SELECT FirstName FROM members WHERE FirstName LIKE '%s'\
    AND LastName LIKE '%s'""") % (FName, LName))
    value = (self.cur.fetchall())
    print(value)
    #except:
        #print('failed')


cla = Database()
cla.search_db(1,'K','D')

value[0][0] is your string

desired login
– desired login

2013-12-19 00:08:32 +00:00
Commented Dec 19, 2013 at 0:08 — desired login
– desired login, Commented Dec 19, 2013 at 0:08

Holy Mackerel · Accepted Answer · 2013-12-19 00:09:59Z

2

You need to access the first element of the list, which is the tuple, then the first element of the tuple, so:

value[0][0]

answered Dec 19, 2013 at 0:09

Holy Mackerel

3,3091 gold badge29 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

How to specify a string value from a returned database returned tuple

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