Click here to Skip to main content
13,094,983 members (79,911 online)
Rate this:
Please Sign up or sign in to vote.
See more:
How to save the image in mysql database in QT? I am using the following code:
What mistake i am making, Please suggest me..

<code> originalPixmap =QPixmap();
            originalPixmap = QPixmap::grabWindow(QApplication::desktop()->winId());
            QString strfname;
            char Data;
            QFile file("D:\\image"+strfname+".jpeg");
            int len=file.size();
            QByteArray buf;
            QSqlQuery query;
            query.prepare("INSERT INTO log (id,grab_date, ip_address, image,logged_user) "
                          "VALUES (:id, :grab_date, :ip_address, :image,  :logged_user)");
            query.bindValue(":grab_date",(QVariant)'2011-04-26 15:55:09');
            query.bindValue ( ":logged_user",(QVariant) hostname);
            bool qry=query.exec();</code>
Posted 16-Jul-11 2:59am
digimanus 18-Jul-11 4:34am
which error you receive?
Gokulnath007 18-Jul-11 5:37am
Nothing is updated in the database.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

query.bindValue(":image",(QVariant); is the bug.

Ensure that all bits of the loaded image were written in the database. Why not copy the file to some store and referring that path. It speeds up the whole process and makes maintenance easier.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 18 Jul 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100