Hi everybody, Trying to save a picture (.jpg or .bmp) to mySQL Database.
I Use put the imagedata of image "Foto_Image" into temp3 ## works put "UPDATE Customers SET Fomage = '"& temp3 & "' where kndnr =" & kundennummer into SQL_Befehl to_i In the Variable Watcher I can see the SQL_Befehl as: UPDATE knddaten SET Foto_image = ' --- here are crazy signs -- ' where kndnr = 3120 ## which looks ok The Error Message shown by the Message box is: You have an error in your SQL Syntax; check the manual that corresponds to your mySQL server version for the right syntax to use near ' ## the crazy signs, but not so much as there are in the picture The problem seems to be, that the image itself will not be transfered. The type of Table Customers and Field Foto_image is set to BLOB Again, I need a helpfull hand best regards and thank you Horst _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
