Click here to Skip to main content
11,804,574 members (91,245 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: VC8.0 C++
How to save the image in mysql database in QT? I am using the following code:
What mistake i am making, Please suggest me..

 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();
Posted 16-Jul-11 2:59am
digimanus at 18-Jul-11 4:34am
which error you receive?
Gokulnath007 at 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
0 OriginalGriff 3,205
1 Maciej Los 1,950
2 KrunalRohit 1,907
3 CPallini 1,855
4 Richard MacCutchan 1,187

Advertise | Privacy | Mobile
Web02 | 2.8.151002.1 | Last Updated 18 Jul 2011
Copyright © CodeProject, 1999-2015
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