Solved

ASP - Upload Files - MySql Blob

Posted on 2009-07-07
8
586 Views
Last Modified: 2012-08-13
I am trying to find out what is the best method on Uploading Images (up to 3) from Classic ASP.  Then have them be stored in a MySql Blob.  Then I will show them in a results page... but that is later.  Any pointers?  My site is being hosted on Godaddy.
0
Comment
Question by:vbjohn
  • 4
  • 4
8 Comments
 

Author Comment

by:vbjohn
ID: 24795302
BTW:
I have the database as:
Table = Property
fields = pImage1, pImage2, pImage3
0
 
LVL 12

Expert Comment

by:R_Harrison
ID: 24795695
The best option is to find out what components GoDaddy has installed - e.g ABCUpload, etc... If they have a component installed then it should be fairly easy and straightforward.   If not, then you will need to look at using a PureASP upload function.
0
 

Author Comment

by:vbjohn
ID: 24795705
ASPUpload
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 12

Expert Comment

by:R_Harrison
ID: 24796321
Take a look at,

http://www.aspupload.com/manual_memory.html

Here you will find example code to do what you are after as well as the full manual for aspupload.
0
 

Author Comment

by:vbjohn
ID: 24814853
That link did not tell me anything.
0
 
LVL 12

Expert Comment

by:R_Harrison
ID: 24831871
OK, will try and paste you some code shortly...
0
 
LVL 12

Accepted Solution

by:
R_Harrison earned 175 total points
ID: 24840354
Below is the code for 2 pages.   Make sure your FORM ACTION points to the database page that you create.

I don't have ASPUPLOAD so I can't test it, but according to the manual this should work, but let me know if you have any problems.
///  THE CODE BELOW IS FOR THE FORM PAGE ////
<FORM METHOD="POST" ENCTYPE="multipart/form-data" ACTION="DatabasePage.asp">
Select file: <INPUT TYPE="FILE" SIZE="40" NAME="FILE1"><BR>
Select file: <INPUT TYPE="FILE" SIZE="40" NAME="FILE2"><BR>
Select file: <INPUT TYPE="FILE" SIZE="40" NAME="FILE3"><BR>
<INPUT TYPE=SUBMIT VALUE="Upload!">
</FORM>
 
 
 
///  THE CODE BELOW IS FOR THE DATABASE HANDLING PAGE ////
<%
Set Upload = Server.CreateObject("Persits.Upload")
Upload.Save
 
// ADD YOUR DATABASE CONNECTION STRING HERE
rs.Open "Property", Connect, 2, 3
rs.AddNew
Set File = Upload.Files("FILE1")
If Not File Is Nothing Then	rs("pImage1").Value = File.Binary
Set File = Upload.Files("FILE2")
If Not File Is Nothing Then	rs("pImage2").Value = File.Binary
Set File = Upload.Files("FILE3")
If Not File Is Nothing Then	rs("pImage3").Value = File.Binary
rs.Update
// CLOSE DATABASE CONNECTION HERE
%>

Open in new window

0
 

Author Closing Comment

by:vbjohn
ID: 31600653
Thanks for the help.  We went a different route.  
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
classic asp checkbox uncheck and check 2 69
Summernote and form validation 10 192
If-Then-Else ASP problem 6 67
Recordset containing single quotes 8 43
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question