retrieving images(blob) from sqlite db

Ali M <[email protected]>
Newsgroups gmane.comp.python.pyqt-pykde
Message-ID <CAMh2k3YtQpUZSXZq_BeKza6eSWAFKnTkXKM1ZsNmPjxnkuTb9Q@mail.gmail.com>
I've created a sqlite db with a blob field and put images in it. how can i
retrieve the images and show them in a qtextbrowser? i want to get the
images with a for loop something like the below code but i don't know how.

def readImage(self):
        cur = self.db.cursor()
        rows = cur.execute("select cover from covers")
        pm = QPixmap()
        for row in rows:
                pic = self.ui.label.setPixmap(QPixmap("row.jpg"))
                self.ui.textBrowser.insertFromMimeData(pic)

_______________________________________________
PyQt mailing list    [email protected]
https://www.riverbankcomputing.com/mailman/listinfo/pyqt
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.