[Qt-interest] Proper way to update a BLOB field

[David Boosalis]

Thanks to all for the help,  I could not find an update example using
placeholders now I can go by your example.

This email list is testimonial to the fact that the  best thing about Qt is
the community it lives in.

On Wed, Apr 14, 2010 at 6:51 AM, Eric Landuyt <eric at datarescue.be> wrote:

> Hello David,
>
> DB> QString str = "UPDATE MyTable SET x='" + QString::number(myClass->x) +
> DB>     "', y='" + QString::number(myClass->y) +
> DB>      ", headerState" + myClass->byteArray +
> DB>       " WHERE id='" + QString::number(myClass->id));
>
> as Andre suggested, you should use placeholders.
> Also, it looks like an '=' is missing right behind your 'headerState'
> column.
>
> --
> Eric Landuyt, Developer - mailto:eric at datarescue.be
> DataRescue sa/nv - http://www.datarescue.com
>
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100414/538e964c/attachment.html