Entry

How do I store (imbed) uploaded MS Office docs in the database?

Mar 18th, 2007 05:03
Jay Shroads,

Per the manual, I have created a record with two fields, a FileName 
(VARCHAR 50) and a FileBlob (MEDIUMBLOB).  In the Visual Editor, I set 
the properties for the FileBlob field to File.  This I think is all I 
need, however the page is not well behaved.

When I add a record, all goes well until I list the page.  There, the 
filename appears, but the icon for the Blob is not clickable, so there 
is no way to retrieve the file.

When I edit the record and attempt to delete the file, it deletes, but 
the filename field is not updated.  

This really seems like a bug and I wanted confirmation that it's not 
something I did wrong.

BTW, using the other technique whereby files are uploaded and stored 
in an external 'file' directory works like a champ.  I will use that 
as a workaround if necessary.  

Anonyone have this working with v3.1 (Build 218)?
Jay