[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pykde
Subject:    Re: [PyQt] Syntax to access a blob column on sqlite
From:       IloChab <ilochab () gmail ! com>
Date:       2010-03-28 15:54:33
Message-ID: 166b1c631003280854q2062329dr11f0953ce7916ed () mail ! gmail ! com
[Download RAW message or body]

I tried in this way:

blobField = QtCore.QVariant ( QtCore.QByteArray ([1,2,3,]) )
query = QtSql.QSqlQuery()
query.prepare("""INSERT INTO blobTable (blobColumn) VALUES(?)""")
query.bindValue(0,(blobField,));
query.exec_();


... and I got no error, but in the DB I find an empty field: (u'')


Which is the correct syntax to store a blob field???
_______________________________________________
PyQt mailing list    PyQt@riverbankcomputing.com
http://www.riverbankcomputing.com/mailman/listinfo/pyqt
[prev in list] [next in list] [prev in thread] [next in thread]