Import Images into DB

[asawyer13]

I have 300-400 image files that I would like to import into my MySQL database to use in in.de.

I believe in.de has a special way that it can save images, etc in the database so that in.de knows what the original extension was.

Would someone have and be willing to share a procedure or small script that would read thru a directory and load the images into database records?

I might be able to do it myself, but I'm thinking if it already exists, it would probably be easier.

Thanks in advance,
Alan

[john w]

Just curious are you looking to load the actual image into the db (blob) or the file path to it.

[asawyer13]

File into a blob.

[v.marino]

Here is a simple procedure that loads all the files found in the "temp" directory to the Picture field of the Customers table.

For further details, you could take a look at the following articles:
LoadBlobFile: http://doc.instantdeveloper.com/eng/?ARTID=6C8CD1AC-03FF-4013-95A2-1126C28ABDE8
ReadDirectory: http://doc.instantdeveloper.com/eng/?ARTID=EF2BBCD1-51DB-11D5-91F3-F44534000000

[asawyer13]

Thanks so much. I will take a look at it tonight.
Alan