Hi Again.. Fortunately I found a way to do this using C++/Qt. Here's the code for who are interested in:
QFile *myFile; QSqlQuery query; QString strQuery; QByteArray myByteArray; // open the image and fill the bytearray myFile = new QFile("/root/hm/variostepsa/fotos_marcopolo/paradiso1.jpg"); myFile->open(IO_ReadOnly); myByteArray = myFile->readAll(); myFile->close(); // Insert the image strQuery = "INSERT INTO Model (Brand, Picture) VALUES ('Subaru', :pic)"; query.prepare(strQuery); query.bindValue(":pic", myByteArray); if (!query.exec()) qWarning("Errrrrrrrorrr"); I don't know if this is optimal, but it works.. :) Thanks to all those reply.. Regards, Hector. El jue, 01-07-2004 a las 20:32, Peter L. Berghold escribiÃ: > On Thu, 2004-07-01 at 11:06, HÃctor Maldonado wrote: > > But LOAD_FILE only works if 'picture.jpg' is placed on the same machine > > where the server is running. > > > > That makes sense. You could of course NFS mount from the remote machine > to the machine you are working from but that is much the same thing. > > Alternatively if you are working in a language like Perl there are other > tricks you can play... -- Ing. HÃctor Maldonado Melgar Dpto. Desarrollo de Software TCI S.A., Lima-Perà [EMAIL PROTECTED] Of.: 421-3222 Cel: 9503-9205 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]