Forums
This topic is locked
mysql image upload
Posted 22 Sep 2006 22:45:10
1
has voted
22 Sep 2006 22:45:10 bryan gray posted:
I think I posted my other post in the wrong spot. Sorrythis is my first post I am having a problem uploading images to my sql database. I have read this is not good in the first place but this is not an issue for me. I can connect to my database and insert text. I am using the insert text field then assiging the insert record behavior in dreamweaver. I can insert as many text fields as I want and update my database that is not my problem. It is when I put in a file field and try to use the insert record behavior that my problem arises. mysql database image field is set to medium blob and binary. in the insert record dialog box when I get down to image field it only gives me a few options as to what form it should be in. ie text,check box, integer, double etc. What value do I need to input the data as? I would greatly appreciate any help in this matter
Replies
Replied 27 Sep 2006 16:59:20
27 Sep 2006 16:59:20 Vince Baker replied:
HI,
The normal process for this is to upload the image to a location and then store the filename in the database so that you can build the link dynamically to display the image stored.
This is possible to code by hand but a really headache and I decided to purchase an extension instead (i do not get any money by the way for recommending extensions!)
This is probably the most universally used extension on the market and is available from this site.
Here is a link: www.dmxzone.com/index.asp?TypeId=7&CatId=529
Regards
Vince Baker
<strong>DMX Zone Manager</strong>
[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]
The normal process for this is to upload the image to a location and then store the filename in the database so that you can build the link dynamically to display the image stored.
This is possible to code by hand but a really headache and I decided to purchase an extension instead (i do not get any money by the way for recommending extensions!)
This is probably the most universally used extension on the market and is available from this site.
Here is a link: www.dmxzone.com/index.asp?TypeId=7&CatId=529
Regards
Vince Baker
<strong>DMX Zone Manager</strong>
[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]