2. PHPRunner General questions
  3. File / Images: don't work
This topic is locked

File / Images: don't work

 		8/24/2007 5:18:18 PM
PHPRunner General questions
M
 mhoerner author

Hi all,
I use a BLOB field. In this field there are .doc and .gif files.
My problem is, that I use "file" in the "view as" setttings, but I don`t see the images. Only the filename.

With the PHP Runner 3.1 the images created on the fly, but with 4.0 and 4.1 this feature don´t work anymore. On "Add" or "Edit" pages I see the images on the fly.
What's go wrong?
Regards,

Chris
Sergey Kornilov admin 8/24/2007

What do you mean "images created on the fly"?
M
 		mhoerner author 8/25/2007

Hello,
this means, that PHPRunner creates a code that extracts images from database on the fly.
This feature works with 3.1, but not with 4.0. Only if I choose "Image" in den "View as" settings, but than I can't download the xls files, that are stored in the same table/field.
With PHPRunner 3.1 I choosed in "View as" the settings: "File" and the images had created on the fly from the database and I could downloaded xls files.
Regards,

Michael Hoerner
M
 		mhoerner author 8/27/2007

Hello Jane,
do you have any idea?
Regards,

Chris
Alexey admin 8/29/2007

Christoph,
unfortunately you can not have images and files displayed in single column.

That functionality doesn't work anymore.
Here is what you can do.

Modify your SQl query on the Edit SQL querytab in PHPRunner.

Add an alias for your file field. I.e.

select

File,

File as Img,

...


Then display both File and Img fields on List page and choose View format - Imagefor Img field.
M
 		mhoerner author 8/29/2007

Hello Alex,
this works. But now I see a red X in the field for the "field as Img" if in this line is a doc. document and no image.
If I have a look on the properties, the name is: table_imager.php?field=img&key1=438
What can I do?
Thanks.
Regards

Chris
M
 		mhoerner author 9/1/2007

Hello Alexey,
do you have any idea?
Thanks,
Best regards,

Chris
Sergey Kornilov admin 9/3/2007

Chris,
post your app to Demo Account and send the URL to support@xlinesoft.com along with problem description.
M
 		mhoerner author 9/9/2007

Hello,
the problem is simple:
If in the field "img" no image but a .doc file, there should be show a default image and not a broken image from database, because in the field: "file", the doc file can be download.
Regards,

Chris
J
 		Jane 9/10/2007

Chris,
you can check field value and assign default image to this field in the List page: Before record processed event on the Events tab.