Forums
This topic is locked
PureASPUpload behavior error
Posted 22 years ago
1
has voted
22 years ago Richard Sheridan posted:
Hi Folks,Recently we purchased PureASPUpload 2.09 and have had some issues making it work. First we made sure that the upload directory was set with the correct permissions for access, second we made sure that we uploaded the script file and third was an error we changed using & and got an expected end of statement error in IE 6. We fixed it so that it doesn't give us this problem anymore but now when I click the submit button it refreshes itself to the same page and fails to upload the image. At some period of fussing, we were able to get it to work and then it ceased working again. The page is a restricted page so here' the code for it. Could someone look over it and see if they can find the discrepancy? The behavior is coupled with an update record behavior. Thanks Rich
CODE-------
<!--#include file="../../ScriptLibrary/incPureUpload.asp" -->
<%
'*** Pure ASP File Upload -----------------------------------------------------
' Copyright (c) 2001-2002 George Petrov, www.UDzone.com
' Process the upload
' Version: 2.0.9
'------------------------------------------------------------------------------
'*** File Upload to: """LGImage""", Extensions: "GIF,JPG,JPEG,JPE", Form: PicUpload, Redirect: "", "file", "1000", "over", "true", "", "" , "200", "200", "", "", "600", "coolGreenFlashProgress.htm", "300", "100"
Dim GP_redirectPage, RequestBin, UploadQueryString, GP_uploadAction, UploadRequest
PureUploadSetup
If (CStr(Request.QueryString("GP_upload"


on error resume next
Dim reqPureUploadVersion, foundPureUploadVersion
reqPureUploadVersion = 2.09
foundPureUploadVersion = getPureUploadVersion()
if err or reqPureUploadVersion > foundPureUploadVersion then
Response.Write "<b>You don't have latest version of ScriptLibrary/incPureUpload.asp uploaded on the server.</b><br>"
Response.Write "This library is required for the current page. It is fully backwards compatible so old pages will work as well.<br>"
Response.End
end if
on error goto 0
GP_redirectPage = ""
Server.ScriptTimeout = 600
RequestBin = Request.BinaryRead(Request.TotalBytes)
Set UploadRequest = CreateObject("Scripting.Dictionary"

BuildUploadRequest RequestBin, """LGImage""", "file", "1000", "over"
If (GP_redirectPage <> "" and not (CStr(UploadFormRequest("MM_insert"



If (InStr(1, GP_redirectPage, "?", vbTextCompare) = 0 And UploadQueryString <> ""

GP_redirectPage = GP_redirectPage & "?" & UploadQueryString
End If
Response.Redirect(GP_redirectPage)
end if
else
if UploadQueryString <> "" then
UploadQueryString = UploadQueryString & "&GP_upload=true"
else
UploadQueryString = "GP_upload=true"
end if
end if
' End Pure Upload
'------------------------------------------------------------------------------
%>
<%
' *** Edit Operations: declare variables
MM_editAction = CStr(Request("URL"

If (Request.QueryString <> ""

MM_editAction = MM_editAction & "?" & Request.QueryString
End If
' boolean to abort record edit
MM_abortEdit = false
' query string to execute
MM_editQuery = ""
%>
<%
' *** Edit Operations: declare variables
MM_editAction = CStr(Request("URL"

If (Request.QueryString <> ""

MM_editAction = MM_editAction & "?" & Request.QueryString
End If
' boolean to abort record edit
MM_abortEdit = false
' query string to execute
MM_editQuery = ""
%>
<%
' *** Update Record: set variables
If (CStr(Request("MM_update"



MM_editConnection = MM_alaskamen_STRING
MM_editTable = "akmen.tblCustomer"
MM_editColumn = "CustomerID"
MM_recordId = "" + Request("MM_recordId"

MM_editRedirectUrl = "www.alaskamen.net/Members/Member_editor.asp"
MM_fieldsStr = "Image1|value"
MM_columnsStr = "Image1|',none,''"
' create the MM_fields and MM_columns arrays
MM_columnsStr = FixColumnsForUpload(MM_fieldsStr,MM_columnsStr)
MM_fieldsStr = FixFieldsForUpload(MM_fieldsStr,MM_columnsStr)
MM_fields = Split(MM_fieldsStr, "|"

MM_columns = Split(MM_columnsStr, "|"

' set the form values
For i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(i+1) = CStr(Request.Form(MM_fields(i)))
Next
' append the query string to the redirect URL
If (MM_editRedirectUrl <> "" And Request.QueryString <> ""

If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> ""

MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If
End If
%>
<%
' *** Update Record: construct a sql update statement and execute it
If (CStr(Request("MM_update"



' create the sql update statement
MM_editQuery = "update " & MM_editTable & " set "
For i = LBound(MM_fields) To UBound(MM_fields) Step 2
FormVal = MM_fields(i+1)
MM_typeArray = Split(MM_columns(i+1),","

Delim = MM_typeArray(0)
If (Delim = "none"

AltVal = MM_typeArray(1)
If (AltVal = "none"

EmptyVal = MM_typeArray(2)
If (EmptyVal = "none"

If (FormVal = ""

FormVal = EmptyVal
Else
If (AltVal <> ""

FormVal = AltVal
ElseIf (Delim = "'"

FormVal = "'" & Replace(FormVal,"'","''"

Else
FormVal = Delim + FormVal + Delim
End If
End If
If (i <> LBound(MM_fields)) Then
MM_editQuery = MM_editQuery & ","
End If
MM_editQuery = MM_editQuery & MM_columns(i) & " = " & FormVal
Next
MM_editQuery = MM_editQuery & " where " & MM_editColumn & " = " & MM_recordId
If (Not MM_abortEdit) Then
' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command"

MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
If (MM_editRedirectUrl <> ""

Response.Redirect(MM_editRedirectUrl)
End If
End If
End If
%>