Solved

ASP - Upload Files - MySql Blob

Posted on 2009-07-07
8
585 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

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…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

776 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