Skip to Content (Press Enter)
UserImage.jpg
Gonçalo Nogueira
1039Views
2Comments
Solved
How to insert a image in a database?
Question
Beginner
Database
Personal Environment
Traditional Web
New to OutSystems
Application Type
Traditional Web

Hey! So I am building an app to show some products and I wanted to show images of that products. I was watching a video and the youtuber created a new attributte and changed the data type to binary and then, createad a gallery view. I am building an tradicional web so I do not have the gallery view... How do I create a field "Image" and show it in a data table?

Thanks

0
0
29 Mar 2021
Copy Link
2021-04-17 09-53-48
José Gonçalves
Solution

To insert in the database you should create an attribute like this one below and assign the image content to it when you upload it, if that's the case. 

For best practices purposes, don't use the main entity (User, Invoice, etc etc) to save the image. Always use a side entity with the main entity foreign key. This will improve your performance when you only want to retrieve the main data.


See solution in context
1
0
29 Mar 2021
Copy Link
2021-04-17 09-53-48
José Gonçalves
Solution

To insert in the database you should create an attribute like this one below and assign the image content to it when you upload it, if that's the case. 

For best practices purposes, don't use the main entity (User, Invoice, etc etc) to save the image. Always use a side entity with the main entity foreign key. This will improve your performance when you only want to retrieve the main data.


1
0
29 Mar 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.