problems with insert

[jarle rudihagen]

I got a mysql table with to collumns: imageID(integer) and imageData(blob).

I'm using the mysql++ API.

I can't seem to insert both the imageID and imageData into the table. When 
I'm just inserting the imageData(the blob field) it works out fine. But as 
soon as I try to pass both fields, things crash.

My coding:
string fill(read_buffer,blen);
strbuf << "INSERT INTO " << MY_TABLE << "values(" << argv[2] << "\"" << 
escape << fill << "\")";
query.exec(strbuf.str());

The following message apear:
[jarle@biri2 jarle]$ ./test_mysql_image "essolog.gif" 
"/home/jarle/essolog.gif" "2"
Error: You have an error in your SQL syntax near 
'/home/jarle/essolog.gif"GIF89a\\\0>\0Õ\0\0ó÷úÞYœþèì$a¢åíô7oª®ÅÜCw®Ž­Ï

can anybody help me???

/Jarle

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php