[Qt-interest] Mysql how to update a blob field

[David Boosalis]

A while ago I asked on this users group how to update a blob with SQLite,
and I got a good answer. Now I have a similiar question for doing it with
Mysql.

Here is what I have been trying to use (which is what works with SQLite)

  QString str= "update filter set"
    + QString(" style=:style")
       QString("  WHERE id=" + QString::number(id));
// style = blob field in mysql table
bool bstatus = query.prepare(str);


The prepare comes back false.  I've tried a lot of permtations on using
place holders, but nothing works.  I've trield to search though the
qtInterst  and Google, but I have yet to find anything.  Any help most
appreciated.

Thanks,
David

PS - using Qt 4.6.2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100519/1987263a/attachment.html