Visualizzazione dei risultati da 1 a 5 su 5
  1. #1

    Problema con pure Asp Upload

    Buongiorno...

    Quello degli upload è un problema che ho con diversi siti...
    ho scaricato l'estensione Pure ASP upload per Dw ma non mi funziona.
    Quello che vorrei che facesse è, oltre l'upload del file, l'aggiungerne il nome sul db in modo da richiamarlo poi all'occorrenza...
    Questo è il codice della mia pagina...
    codice:
     <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
    
    
    <%
    '*** Pure ASP File Upload -----------------------------------------------------
    ' Copyright (c) 2001-2002 George Petrov, www.UDzone.com
    ' Process the upload
    ' Version: 2.0.9
    '------------------------------------------------------------------------------
    '*** File Upload to: """public/loghi""", Extensions: "GIF,JPG,JPEG,BMP,PNG", Form: form1, Redirect: "", "file", "", "over", "true", "", "" , "", "", "", "", "600", "", "", ""
    
    Dim GP_redirectPage, RequestBin, UploadQueryString, GP_uploadAction, UploadRequest
    PureUploadSetup
    
    If (CStr(Request.QueryString("GP_upload")) <> "") Then
      on error resume next
      Dim reqPureUploadVersion, foundPureUploadVersion
      reqPureUploadVersion = 2.09
      foundPureUploadVersion = getPureUploadVersion()
      if err or reqPureUploadVersion > foundPureUploadVersion then
        Response.Write "You don't have latest version of ScriptLibrary/incPureUpload.asp uploaded on the server.
    "
        Response.Write "This library is required for the current page. It is fully backwards compatible so old pages will work as well.
    "
        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, """public/loghi""", "file", "", "over"
      
      If (GP_redirectPage <> "" and not (CStr(UploadFormRequest("MM_insert")) <> "" or CStr(UploadFormRequest("MM_update")) <> "")) Then
        If (InStr(1, GP_redirectPage, "?", vbTextCompare) = 0 And UploadQueryString <> "") Then
          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: (Modified for File Upload) declare variables
    
    Dim MM_editAction
    Dim MM_abortEdit
    Dim MM_editQuery
    Dim MM_editCmd
    
    Dim MM_editConnection
    Dim MM_editTable
    Dim MM_editRedirectUrl
    Dim MM_editColumn
    Dim MM_recordId
    
    Dim MM_fieldsStr
    Dim MM_columnsStr
    Dim MM_fields
    Dim MM_columns
    Dim MM_typeArray
    Dim MM_formVal
    Dim MM_delim
    Dim MM_altVal
    Dim MM_emptyVal
    Dim MM_i
    
    MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
    If (UploadQueryString <> "") Then
      MM_editAction = MM_editAction & "?" & Server.HTMLEncode(UploadQueryString)
    End If
    
    ' boolean to abort record edit
    MM_abortEdit = false
    
    ' query string to execute
    MM_editQuery = ""
    %>
    <%
    ' *** Insert Record: (Modified for File Upload) set variables
    
    If (CStr(UploadFormRequest("MM_insert")) = "form1") Then
    
      MM_editConnection = MM_conn_windistr_STRING
      MM_editTable = "tbl_marche"
      MM_editRedirectUrl = "new_link.asp"
      MM_fieldsStr  = "marcaName|value|logo|value|catalogo|value|descrizioneMarca|value"
      MM_columnsStr = "marcaName|',none,''|logo|',none,''|catalogo|none,none,NULL|descrizioneMarca|',none,''"
    
      ' create the MM_fields and MM_columns arrays
      MM_fields = Split(MM_fieldsStr, "|")
      MM_columns = Split(MM_columnsStr, "|")
      
      ' set the form values
      For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
        MM_fields(MM_i+1) = CStr(UploadFormRequest(MM_fields(MM_i)))
      Next
    
      ' append the query string to the redirect URL
      If (MM_editRedirectUrl <> "" And UploadQueryString <> "") Then
        If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And UploadQueryString <> "") Then
          MM_editRedirectUrl = MM_editRedirectUrl & "?" & UploadQueryString
        Else
          MM_editRedirectUrl = MM_editRedirectUrl & "&" & UploadQueryString
        End If
      End If
    
    End If
    %>
    <%
    ' *** Insert Record: (Modified for File Upload) construct a sql insert statement and execute it
    
    Dim MM_tableValues
    Dim MM_dbValues
    
    If (CStr(UploadFormRequest("MM_insert")) <> "") Then
    
      ' create the sql insert statement
      MM_tableValues = ""
      MM_dbValues = ""
      For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
        MM_formVal = MM_fields(MM_i+1)
        MM_typeArray = Split(MM_columns(MM_i+1),",")
        MM_delim = MM_typeArray(0)
        If (MM_delim = "none") Then MM_delim = ""
        MM_altVal = MM_typeArray(1)
        If (MM_altVal = "none") Then MM_altVal = ""
        MM_emptyVal = MM_typeArray(2)
        If (MM_emptyVal = "none") Then MM_emptyVal = ""
        If (MM_formVal = "") Then
          MM_formVal = MM_emptyVal
        Else
          If (MM_altVal <> "") Then
            MM_formVal = MM_altVal
          ElseIf (MM_delim = "'") Then  ' escape quotes
            MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'"
          Else
            MM_formVal = MM_delim + MM_formVal + MM_delim
          End If
        End If
        If (MM_i <> LBound(MM_fields)) Then
          MM_tableValues = MM_tableValues & ","
          MM_dbValues = MM_dbValues & ","
        End If
        MM_tableValues = MM_tableValues & MM_columns(MM_i)
        MM_dbValues = MM_dbValues & MM_formVal
      Next
      MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"
    
      If (Not MM_abortEdit) Then
        ' execute the insert
        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 <> "") Then
          Response.Redirect(MM_editRedirectUrl)
        End If
      End If
    
    End If
    %>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <script language="JavaScript">
    <!--
    
    function checkFileUpload(form,extensions,requireUpload,sizeLimit,minWidth,minHeight,maxWidth,maxHeight,saveWidth,saveHeight) { //v2.09
      document.MM_returnValue = true;
      for (var i = 0; i<form.elements.length; i++) {
        field = form.elements[i];
        if (field.type.toUpperCase() != 'FILE') continue;
        checkOneFileUpload(field,extensions,requireUpload,sizeLimit,minWidth,minHeight,maxWidth,maxHeight,saveWidth,saveHeight);
    } }
    
    function checkOneFileUpload(field,extensions,requireUpload,sizeLimit,minWidth,minHeight,maxWidth,maxHeight,saveWidth,saveHeight) { //v2.09
      document.MM_returnValue = true;
      if (extensions != '') var re = new RegExp("\.(" + extensions.replace(/,/gi,"|").replace(/\s/gi,"") + ")$","i");
        if (field.value == '') {
          if (requireUpload) {alert('File is required!');document.MM_returnValue = false;field.focus();return;}
        } else {
          if(extensions != '' && !re.test(field.value)) {
            alert('This file type is not allowed for uploading.\nOnly the following file extensions are allowed: ' + extensions + '.\nPlease select another file and try again.');
            document.MM_returnValue = false;field.focus();return;
          }
        document.PU_uploadForm = field.form;
        re = new RegExp(".(gif|jpg|png|bmp|jpeg)$","i");
        if(re.test(field.value) && (sizeLimit != '' || minWidth != '' || minHeight != '' || maxWidth != '' || maxHeight != '' || saveWidth != '' || saveHeight != '')) {
          checkImageDimensions(field,sizeLimit,minWidth,minHeight,maxWidth,maxHeight,saveWidth,saveHeight);
        } }
    }
    
    function showImageDimensions(fieldImg) { //v2.09
      var isNS6 = (!document.all && document.getElementById ? true : false);
      var img = (fieldImg && !isNS6 ? fieldImg : this);
      if (img.width > 0 && img.height > 0) {
      if ((img.minWidth != '' && img.minWidth > img.width) || (img.minHeight != '' && img.minHeight > img.height)) {
        alert('Uploaded Image is too small!\nShould be at least ' + img.minWidth + ' x ' + img.minHeight); return;}
      if ((img.maxWidth != '' && img.width > img.maxWidth) || (img.maxHeight != '' && img.height > img.maxHeight)) {
        alert('Uploaded Image is too big!\nShould be max ' + img.maxWidth + ' x ' + img.maxHeight); return;}
      if (img.sizeLimit != '' && img.fileSize > img.sizeLimit) {
        alert('Uploaded Image File Size is too big!\nShould be max ' + (img.sizeLimit/1024) + ' KBytes'); return;}
      if (img.saveWidth != '') document.PU_uploadForm[img.saveWidth].value = img.width;
      if (img.saveHeight != '') document.PU_uploadForm[img.saveHeight].value = img.height;
      document.MM_returnValue = true;
    } }
    
    function checkImageDimensions(field,sizeL,minW,minH,maxW,maxH,saveW,saveH) { //v2.09
      if (!document.layers) {
        var isNS6 = (!document.all && document.getElementById ? true : false);
        document.MM_returnValue = false; var imgURL = 'file:///' + field.value.replace(/\\/gi,'/').replace(/:/gi,'|').replace(/"/gi,'').replace(/^\//,'');
        if (!field.gp_img || (field.gp_img && field.gp_img.src != imgURL) || isNS6) {field.gp_img = new Image();
    		   with (field) {gp_img.sizeLimit = sizeL*1024; gp_img.minWidth = minW; gp_img.minHeight = minH; gp_img.maxWidth = maxW; gp_img.maxHeight = maxH;
      	   gp_img.saveWidth = saveW; gp_img.saveHeight = saveH; gp_img.onload = showImageDimensions; gp_img.src = imgURL; }
    	 } else showImageDimensions(field.gp_img);}
    }
    //-->
    </script>
    <title>Documento senza titolo</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <link href="Css/winasp.css" rel="stylesheet" type="text/css">
    </head>
    
    <body>
    <form action="<%=MM_editAction%>" method="post" enctype="multipart/form-data" name="form1" onSubmit="checkFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,'','','','','','','');return document.MM_returnValue">
      <table align="center">
        <tr valign="baseline">
          <td nowrap align="right">MarcaName:</td>
          <td>
            <input type="text" name="marcaName" value="" size="32">
          </td>
        </tr>
        <tr valign="baseline">
          <td nowrap align="right">Logo:</td>
          <td>
            <input name="logo" type="file" id="logo" onChange="checkOneFileUpload(this,'GIF,JPG,JPEG,BMP,PNG',true,'','','','','','','')">
    </td>
        </tr>
        <tr valign="baseline">
          <td nowrap align="right">Catalogo:</td>
          <td>
            <select name="catalogo">
            </select>
          </td>
        </tr>
        <tr>
          <td nowrap align="right" valign="top">DescrizioneMarca:</td>
          <td valign="baseline">
            <textarea name="descrizioneMarca" cols="50" rows="5"></textarea>
          </td>
        </tr>
        <tr valign="baseline">
          <td nowrap align="right"></td>
          <td>
            <input type="submit" value="Inserisci record">
          </td>
        </tr>
      </table>
      <input type="hidden" name="MM_insert" value="form1">
    </form>
    
    
    </p>
    </body>
    </html>

  2. #2
    usa l'upload dell'utente baol74 (lo trovi nella sua firma)

  3. #3
    Mannaggia... troppo complesso... ma ora con pure asp upload ho fatto un passo avanti... fa l'upload ma però nella cartella di root e non in public/loghi come da me settato...

  4. #4
    no un attimo... ulteriore aggiornamento... fa l'upload nella cartella giusta ma non la segna nel db...

  5. #5
    Ciao.. segui il consiglio di Santino.. Quello di Baol è 100 volte piu semplice poi il codice si riduce di tantissimo.. non si capisce niente dal tuo.. troppo lungo.. VVoVe: guarda questo:


    <%
    Dim oUpload
    Set oUpload= new cUpload
    With oUpload
    .SetDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("/mdb-database/database.mdb"),"SELECT Top 1 * FROM tabella"
    .EnabledAspUpload = False
    .EnabledImageSize = true
    .EnabledLog = False
    .AutoRename = True
    .Overwrite = False

    .SetPath "foto"
    .Load
    .MoveFirst
    if .EOF then
    NumFiles = .Count()
    Response.write "0 Files caricati su " & NumFiles &" : controlla le dimensioni e il tipo di file."
    %>
    <center>


    <input type="button" value="Indietro" onClick="history.back()" name="button22" style="color: #000000; font-size: 8 pt">
    </center>
    <%
    else
    .Database.Open()
    While Not .EOF
    if .Files("InputName")="campo" then
    .Files("DestPath") = Server.MapPath("foto")
    .Save
    else
    .Files("Name")=session("session.sessionID")

    .Save
    'Inserimento dei valori
    .Database.Fields("campo1") = .Form("campo1")
    .Database.Fields("campo2") = .Form("campo2")
    .Database.Fields("campo3") = .Form("campo3")
    .Database.Fields("campo4") = .Form("campo4")

    .Database.Fields("immagine") = .GetFileName()

    .Database.AddNew()
    end if
    %>

    Inserimento immagine + vari campi in Database.. hai visto quanto è piu corto?? semplice no??
    Cerca lo script di baol..

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.