2. PHPRunner General questions
  3. 'No file chosen', after saving to varbinary
This topic is locked

'No file chosen', after saving to varbinary

 		8/4/2016 10:09:21 AM
PHPRunner General questions
P
 PHPRunnerExplorer author

Hi,
After Editing and choose a jpg in a varbinary field, the Edit screen displays the name of the file.
After Saving, in Sql Server you can see the binary information filled in.
However, when going back into the Edit screen in the PHPRunner application, the field still displays "No file chosen".
How can you get it to display either the jpg filename, or the thumbnail? If edit the Field properties and check 'Create thumbnails on the fly', it displays a confusing Keep/Delete/Update radio button group, but still says 'No file chosen'.
Sergey Kornilov admin 8/4/2016

To setup an upload of files directly to the database you need to have two binary fields (one for main image and another one for thumbnail) and also one text field to save the file name.
I must add that saving files on file system is much easier to setup, you only need one text field to store multiple images, thumbnails etc.
P
 		PHPRunnerExplorer author 8/4/2016

I'd prefer to leave the files directly on the server, as you're suggesting. But all of our other applications store them in the database, so I have to follow that pattern.



To setup an upload of files directly to the database you need to have two binary fields (one for main image and another one for thumbnail) and also one text field to save the file name.
I must add that saving files on file system is much easier to setup, you only need one text field to store multiple images, thumbnails etc.