Execute SQL

[dcatki]

Hi,

I am trying to use "Execute SQL" to pass a Filemaker field value into a MySQL database.

INSERT INTO `tbltest` ( `title` , `Picture` ) VALUES ('" & Art Database::title & "'), '');

I cannot get the field value to pass, instead the uploaded value is " & Art Database::title & ".

Will BLOBs upload using this method?

Thanks,

David

[stash]

"INSERT INTO tbltest SET

title = "" & Art Database::title & "",

Picture = "" "

Try to copy-paste this one to your calculated SQL Result of "Execute SQL" function.

As I know, you cant send the value(picture) from FileMaker to the BLOB field of mySQL server...neighter some value(picture) from mySQL to the Container field of FileMaker.