Sql语句只返回布尔值

Question

我想填充我的组合框" box_personal ";与我的数据库中的个性，但它只返回"true"

def kombobox_fuellen(self):
result=[]
abfrage = "SELECT DISTINCT(Personalnummer) as Personalnummer FROM mitarbeiter"
result = query.exec(abfrage)
my_list = [r for r, in result]
self.Box_personal.addItems(my_list)

我也试过了，它打印出所有的个人数字，但将每个数字作为自己的条目添加到框

def kombobox_fuellen(self):
# SQL Abfrage aller daten
result=[]
abfrage = "SELECT Personalnummer FROM mitarbeiter"
query.exec(abfrage)
while query.next():
result = str(query.value(0))
print(str(result))
# self.Box_airline.addItems("")
self.Box_personal.addItems(result)

Answer 1

我犯了一个小错误，下面是代码，现在可以运行了:

def kombobox_fuellen(self):
# SQL Abfrage aller daten
abfrage = "SELECT Personalnummer FROM mitarbeiter"
query.exec(abfrage)
while query.next():
result = str(query.value(0))
print(str(result))
# self.Box_airline.addItems("")
self.Box_personal.addItem(result)

问题出在addItems ->改为addItem和wolla