putting container information into an SQL database

[timmy]

i am trying to move some information from a filemaker database to an SQL database.

i am trying to accomplish this by using the ExecuteSQL script. It works fine for fields that are text or numbers, but i am having trouble making the move for container fields.

specifically, i am trying to move an image from a field named "thumbnail"

any suggestions? anybody done this?

[LiveOak]

What is the field type in the SQL database?

-bd

[timmy]

the field type is currently "image"

should it be something else?

[Kurt Knippel]

Hmm, you could try a BLOB type. SQLServers "Image" field may be expecting something specific rather than a general binary object which is what a container field is. Or it may be a limitation of ODBC.

[timmy]

i think this may be a limitation of my understanding of SQL queries.

lets say i want to insert a file named "simple.jpg" into a field named "image" of type BLOB.

what is the query to do this?