Hello, I am currently struggling with something.
- I have a database in MSSQL that has some images. They are currently stored as DataType:Image.
- I am binding a perspective table to a named query, this named query returns an image/images.
However the table won’t display the image and I’ve googled around for a bit now. I’ve come across a forum: View Images from Database - #5 by jpark where they help you with a transform script.
- I’ve tried the transform script which is:b64Image = “data:imagef;base64,%s”%value return b64Image. It’ll convert the returned sql value into base64 string so that the perspective table can display it. But I can NOT get it to work. I’ve tried changing the Data Type from image to: nvarchar(max) and varbinary(max). I’ve converted the image straight into base64 with some programming magic, and the table still won’t be able to display the image. What Can I do to display a picture in my Perspective table from a database.