How can show the full absolute path of an image which filename is store in database?

Scriptcase 8 Discussion
#1

I would like to export data from my grid using csv; the problem is one of the columns has images(filename stored in db: they are beign displayed well when I set the field type to image(filename)). What I want is to display the full absolute path reference from my domain; for instance: http://mysite.com/myfolder/image.png in the column instead of image. I tried leaving the column type to text, it didn’t work; How can I acheive that in scriptcase?

#2

I assume that the full path before the files is constant? Then you could consider adding another field with the full details (initially you can fill this field correctly using sql). Then in your application you can use the validate event to apply this field in your code.

#3

I get what you are saying; I can even use manual lookup; even sql to concat the constant path part. The problem is I don’t know where scriptcase case stores those image neither the place to set where it should store images when a user is inserting or update the records.

#4

Yeah thanks, it helps me understand more but what I need is to have http://mysite.com/myfolder/image.png displayed in the grid not just where the images are stored.
So following what you are saying; should add my domain http://mysite.com before the session data(glo_nm_path_imagens) value

#5

I cann’t see my form application listed among session variables as you describe @GunterEibl
I am using the absolute path to display the image in a blank application and would like also my users to know the absolute path of the image file.

#6

You have to load and run the former application within Scrept case once.
Then reload View > Data in session.

#7

I see now that’s why, when I run directly the blank application without running the former application it is giving null value. Thanks @GunterEibl for the explaination; now the problem is according to the architecture of the system the blank should access that path files even when the former application is not running. By the way the users who are accessing the blank application don’t have access to the former application.

#8

this is interesting issue because many users would want to lad images from different locations:

  • same site as project but different folder
  • different site
  • same site i.e. ./_lib/img/file01.png
  • database i.e BLOB()

I’m surprised Netmake includes so many useless exaples Apps in the product but does not give users things we need to learn and understand… :frowning: