I need help with images sent with the form object
Author: James H.The website I created for my club uses the form object in many places and it works great. Recently, they added a requirement that members submit an image of their driver’s license. The attachment option in the form object seems to work perfectly.
My problem is that I am completely clueless as to the parameters for the field in the SQL table where I want members to be able to upload the image. I think an image is a binary string.
What information do I need to setup in SQL field structure for [TYPE – LENGTH/VALUES – DEFAULT – COLLATION – ATTRIBUTES – NULL – INDEX – A_I]?
It would be GREATLY APPRECIATED if someone could help me with the field setup to allow jpg, png, bmp, and maybe pdf files no larger than 1 meg.
Thanks in advance for your help! You folks have always been great when it comes to helping out!
Hi James.
I believe if you add an attachment field, the field on the Database will probably be a simple string pointing to the location of the file on the server, while the image itself will be easily findable in the server itself.
No need to apply any particular format to the Database's column
Let me know if it works for you
Stefano