Python pyqt database query on a qlist

Question

If you please can help me, I would appreciate it

I'm doing a query of sqlite3 and I want to show the result on a QListWidget

for row in c.execute("SELECT * FROM typem WHERE Type LIKE ?",('%'+'b'+'%',)):
     test = ''
     test += str(row[1])
     print test
     self.listWidget.addItems(test)

On the "print teste" is showing this

And on the "addItems" saves like this

Can you please help me? Thanks

Change self.listWidget.addItems(test) to self.listWidget.addItem(test) — eyllanesc
– eyllanesc, Commented Sep 2, 2017 at 15:11

eyllanesc · Accepted Answer · 2017-09-02 15:15:35Z

1

When you use the addItems() method the QListWidget class assumes that you are passing an iterable so you get each element, and a string is an iterable, so you get that behavior. The solution in your case is to change addItems() to addItem().

answered Sep 2, 2017 at 15:15

eyllanesc

246k19 gold badges205 silver badges282 bronze badges

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

1 Comment

ShwSvn Over a year ago

Hi mate, I'm sorry for bothering you again, it is possible to add you in some place to ask you a question? It's not to see any code of anything

Collectives™ on Stack Overflow

Python pyqt database query on a qlist

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related