This topic is locked
[SOLVED]

 Problem viewing medium blob in 'view'

1/20/2005 8:12:01 PM
PHPRunner General questions
author

Hi again,
I have 3 blobs (<65k) and 3 medium blobs (<8meg) in my database. I connfigured PHPRunner to display the 3 blobs on the main display of the database. That worked great. Then I set it so that the medium blobs would not be displayed in the main display, but only in the 'view'. Strangely though, it is not showing the pictures. I also uploaded a smaller pic into the medium blob but it is still not displaying, all it shows is the image indicating there is no picture.
Any ideas why this is happening?

Sergey Kornilov admin 1/21/2005

Zack,
please zip and send to support@xlinesoft.com your PHP files, sample MySQL database, your project file and a sample picture. I'll find what's wrong running it on my local box.

Z
Zack 1/22/2005

Thanks Sergey for your quick replies.
Here is an interesting note to this. I just used PHPRunner to have the big pictures be displayed on the main page, and have the thumbnails displayed on the 'view' page, and the thumbnails were not displayed on the view page, but the big pictures where displayed on main page.
I'm working on downloading the database so I can send to you...

Z
Zack 1/22/2005

I just occured to me that I wasnt selecting the 'view as' field in step 7. Interestingly though I noticed that if you uncheck a field on the list page, that is make it not be displayed, the interface grays out the 'view as' field , even though you can still check it to be displayed in the 'view page'.
Anyway so what i did was change all the stored pictures to database image, and then unchecked the ones I didnt want to be displayed on the list page. The viewas field then was grayed out, but the database image was still listed.
Unfortunetly this did not solve the problem.
Next Im going to try to just store it as a file based image.

Z
Zack 1/22/2005

I hope no one minds all these posts.
It looks like how the PHPRunner works is that in order for a picture stored in the database to be displayed on the 'view' page it must also be displayed on the list page. Because the images were displayed once i set it up that way.
Alternatively, storing the path of the image works regardless of whether it is displayed on both pages.
Im wondering if it is more efficient to store the images as relative paths in the database and not as blobs...