SQL BLOB to IMAGE

Archived Topics
1

I have an application where the user will make a selection from a combo box that is bound to a table in a MYSQL (remote) database.

I need to be able to load an associate BLOB (jpg) from the database and show it on the screen.

Is there a way to do this ? :confused:

2

Yes, you should be able to put this together. There are a few different routes you could go, I’d do something like this:

  1. Retrieve the BLOB with a query
  2. Get a temp file with fpmi.file.getTempFile(“jpg”)
  3. Write the data to the temp file with fpmi.file.writeFile
  4. Set an image component’s “path” property to the URL of the temp file (“file://”+tempFilePath")