Elimintaing Headers in Binary Images

[juddkirklin]

I am trying to save images in a VFP TABLE General field (OLE) and display them on a web site. The problem I am having is that VFP6.0 saves header information with the image which interferes with displaying the image. How can I save images without the header information being saved?

Thank you for your help in advance.

 

[baltman]

Most people don't recommend storing data files in General fields as there is no programatic way to pull the files back out.

Why not store the files in a graphics folder and store only the path in the table?

Brian

 

[Mike Lewis]

Hi juddkirklin,

I agree with Baltman. A general field is not appropriate for this sort of job. Use free-standing image files instead.

Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[juddkirklin]

I want to execute a single SQL statement that brings me the data I need from each record including the image that corresponds with the other information in the record. This saves me having to go back to the server 20 times to get images that correspond to the 20 records I read with the SQL statement. The Binarywrite Method works great to display the image if it does not have textual header information. This is my problem, FoxPro stores header information in the image. How do I get an image without header information in a general field?

Thank you

Judd

 

[rgbean]

Judd,
If you must, use FILETOSTR() to convert the image file into a binary string, then store the string in a Memo field. No header, just data.

Rick