Click here to Skip to main content
11,582,850 members (76,859 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: VC8.0
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 365
1 Sergey Alexandrovich Kryukov 220
2 virusstorm 209
3 Kornfeld Eliyahu Peter 165
4 Andy Lanng 139
0 OriginalGriff 1,403
1 Sergey Alexandrovich Kryukov 970
2 Abhinav S 696
3 F-ES Sitecore 505
4 Suvendu Shekhar Giri 503

Advertise | Privacy | Mobile
Web04 | 2.8.150603.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