|
| |
|
|
bige
Posts: 42
Joined: 12/26/2003
Status: offline
 |
Upload Images using .ASP and MS Access - 1/8/2004 0:15:29
Hello all,
I need to be able to have users upload images as well as put in product information contact name etc and then be able to write that information to an Access database using the Options "send to database" in FrontPage. I have the database working but I read that in order to use the file upload you have to use htm instead of asp. So how do I combine the two. I need to store images in the database and then be able to pull them up when searching through catagories.
Any suggestions?
Thanks
Michael
|
|
|
|
bige
Posts: 42
Joined: 12/26/2003
Status: offline
|
RE: Upload Images using .ASP and MS Access - 1/8/2004 1:01:15
I tried the following:
I created a page called upload.htm and added a form then inserted the file upload to that page. The in form properties I told it to post to products.asp page. On the Products.asp page is where I collect all of my data and store it to the database after clicking submit. I told it to have a hidden field of "Image" with a value of <%=request.form("Image")%> hoping that it would capture the path from the htm and then add that path to the database. no such luck however.
| |
|
|
|
Googly
Posts: 4
Joined: 1/8/2004
Status: offline
|
RE: Upload Images using .ASP and MS Access - 1/8/2004 15:12:09
bige,
When you post the image and attempt to store it in the database the field in the database must be set as "OLE Object" and there is other information that needs to be entered (i.e file size, data type etc). I have not yet been able to post binary data to a DB using the FP Form wizard....however.......
At the risk of sending anyone off on a non-FP solution, this is a compilation of forms that I have used successfully to add binary data (JPG's, PDF's etc) to an Access database along with username, password, contact info etc. I'm not sure how ASP Saavy you are but this set of scripts is easily "Personalized" for the mid-line and above users: You can also integrate the script code into your FP generated posting forms and carry out multiple database operations on the same "Updte" page.
My apologies to the moderator for posting another's site here:
http://www.stardeveloper.com/articles/display.html?article=2001033101&page=1
If you have to stick to the FP Database From wizard then your next best alternative is to create a writeable directory in your web and use the FP Upload component to dump the file there. Alot of ISP's don't allow write access to the general public so it may be difficult to allow "everyone" the ability to upload an image. (not to mention space wasting for your web dir!).
I hope I didn't confuse you more! Good luck with it!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 