Solved

Upload file and data to database

Posted on 2014-02-19
6
403 Views
Last Modified: 2014-02-20
Hi Experts,

I've got 20 documents with over 114 concurrent questions about 36 each. So I've put them in a table in my database and I've made ajax drag and drop interface so document management is easy.

The input part ready but now I have to complete the part that saves all fields into the database.

Because every document has a file upload field I guess I can't use request.from.

This is my best try:

<!--#INCLUDE FILE="config.asp"-->
<!--#INCLUDE FILE="requestobjects.asp"-->
<%
Server.ScriptTimeOut = 300
Response.Buffer = False
Dim oPseudoRequest 
Set oPseudoRequest = new PseudoRequestDictionary
oPseudoRequest.ReadRequest()
oPseudoRequest.ReadQuerystring(Request.Querystring)
documentID= SQLEncode(oPseudoRequest.Form("docmentID"))

' Eerst uitvragen aan de database wat we voor dit document moeten opslaan
sql="SELECT DISTINCT entree_items.valuename, entree_fieldtypes.datetype FROM entree_fieldtypes INNER JOIN (entree_items INNER JOIN entree_ItemPerDocument ON entree_items.fieldtypeID = entree_ItemPerDocument.itemID) ON entree_fieldtypes.fieldtypeID = entree_items.fieldtype WHERE entree_ItemPerDocument.documentID=1;"
'response.write sql
'response.end
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open SQL, cs
teller=0
sSQL = "SELECT * FROM entree_fase1"
Set oRS = Server.CreateObject("ADODB.RecordSet")
oRS.Open sSQL, cs, 1, 3
oRS.AddNew
Do While Not RS.EOF
	if RS("datetype") = "image" then
		oRS(RS("valuename")).AppendChunk oPseudoRequest.Form(RS("valuename")).Binary 
	else 
		oRS(RS("valuename")) = SQLEncode(oPseudoRequest.Form(RS("valuename")))
	end if

RS.MoveNext
Loop
oRS.Update
oRS.Close
Set oRS = Nothing

response.redirect("default.asp")

Function SQLEncode(ByVal s)
	SQLEncode = Cstr("" & s)
	SQLEncode = Replace(SQLEncode,"'","''")
End Function
Set oPseudoRequest = Nothing
cs.Close
Set cs = Nothing
%>

Open in new window



As you can see I use Sybe Vissers pure ASP upload but I can't get lines 25 or 27 to work. I try to inject the fieldname from recordset RS  into the recordset oRS.

What should be my syntax? Or am I completely wrong here?

Thanks?
0
Comment
Question by:Steynsk
  • 3
  • 3
6 Comments
 
LVL 33

Expert Comment

by:Big Monty
ID: 39870724
Because every document has a file upload field I guess I can't use request.from.

why not? :)

how are the file upload fields named? I assume they all have some sort matching text, maybe like fileUpload1, fileUpload2, fileUpload3, etc. if thats the case, you can just loop through the Request.Form object and grab the field names that way:

for each fileName in Request.Form
    if InStr( fileName, "fileUpload" ) > 0 then    '-- this is a file field
          theFile = Request.Form( fileName )
          '-- process the file however
    end if
next

Open in new window

0
 
LVL 1

Author Comment

by:Steynsk
ID: 39871187
But will that upload my file into datsbase as a blob file? (Date type "image" in ms sql).
0
 
LVL 33

Accepted Solution

by:
Big Monty earned 500 total points
ID: 39871220
the code i gave you is just a method in which you can get each file to the server using Request.Form. however you save it is up to you, but if it were up to me, I would save the files to some folder on your site (maybe call it /uploads/) and save the path to the file in the database.

This is a lot more efficient, and a lot easier to code than appending file chunks to the database
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

by:Steynsk
ID: 39871386
I understand but the files uploaded are scanned passport an id cards and should be stored more secure than basic. But maybe i should first upload them to a upload folder on the webserver and then post proces them to a blob in my db. I will search for a scrip to make this post proces work.
Maybe you have me led to an alternative solution that will solve my problem. I'll give it a try and get back to you.
0
 
LVL 33

Assisted Solution

by:Big Monty
Big Monty earned 500 total points
ID: 39871477
just keep in mind it's going to put a heavy load on your database server, as once you get the files in the database, you still need to stream them out, which the database will need to do. If you do go this route, I agree that first getting the files uploaded first, then processing them is the right approach.
0
 
LVL 1

Author Closing Comment

by:Steynsk
ID: 39873213
thanks for the advise
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Displaying number of records depdning on table contents - classic asp 13 38
classic asp checkbox uncheck and check 2 62
JSON error 4 64
Choose the older file FSO 6 48
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/…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

772 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