2. PHPRunner General questions
  3. Problem imbedding MS Office file (or any file actually) in Blob
This topic is locked

Problem imbedding MS Office file (or any file actually) in Blob

 		3/18/2007 9:14:05 AM
PHPRunner General questions
J
 jshroads author

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, and pointed to the FileName field. 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
Alexey admin 3/19/2007

Jay,
open List page in Visual editor then double-click your field.

Choose File there.
J
 		jshroads author 3/21/2007

Got that working, so the BLOB now shows as a clickable link and all seems fine, except for two issues:

  1. There are times when the MySQL server says it has gone away when I try to add a file. It's local to my PC, so unsure what this is.
  2. If I display the BLOB on the edit screen, I see the Keep/Delete/Update radio buttons. If I use the Delete button and Save, the BLOB is deleted, it's filename is not, and it shows as clickable. Clicking on it returns an empty document.
    I'm bypassing the issue by not displaying the BLOB, and deleteing the entire record that contains it as a workaround.
    Geat product, but this one function does not seem to work as advertised.
    Regards,

    Jay
J
 		Jane 3/22/2007

Jay,
thank you for pointing me to this bug.

We'll fix it in the next PHPRunner update. It will be ready next week.