file upload problem

Discussion in 'C#' started by sinner8347, Dec 13, 2005.

  1. #1
    hi guys i got these source code from net and when i try to use it i face problem,can pls help me identify the problem?

    the error message is
    Variable is undefined: 'RS'
    /new/uploadexmple.asp, line 42



    <%@ Language=VBScript %>
    <%Option Explicit%>
    <!-- #include file="upload.asp" -->
    <%

    'NOTE - YOU MUST HAVE VBSCRIPT v5.0 INSTALLED ON YOUR WEB SERVER
    ' FOR THIS LIBRARY TO FUNCTION CORRECTLY. YOU CAN OBTAIN IT
    ' FREE FROM MICROSOFT WHEN YOU INSTALL INTERNET EXPLORER 5.0
    ' OR LATER.


    ' Create the FileUploader
    Dim Uploader, File
    Set Uploader = New FileUploader

    ' This starts the upload process
    Uploader.Upload()

    '******************************************
    ' Use [FileUploader object].Form to access
    ' additional form variables submitted with
    ' the file upload(s). (used below)
    '******************************************
    Response.Write "<b>Thank you for your upload " & Uploader.Form("fullname") & "</b><br>"

    ' Check if any files were uploaded
    If Uploader.Files.Count = 0 Then
    Response.Write "File(s) not uploaded."
    Else
    ' Loop through the uploaded files
    For Each File In Uploader.Files.Items

    ' Check where the user wants to save the file
    If Uploader.Form("saveto") = "disk" Then

    ' Save the file
    File.SaveToDisk "C:\UploadedFiles"

    ElseIf Uploader.Form("saveto") = "database" Then

    ' Open the table you are saving the file to
    Set RS = Server.CreateObject("ADODB.Recordset") <---------line 42
    RS.Open "MyUploadTable", "CONNECT STRING OR ADO.Connection", 2, 2
    RS.AddNew ' create a new record

    RS("filename") = File.FileName
    RS("filesize") = File.FileSize
    RS("contenttype") = File.ContentType

    ' Save the file to the database
    File.SaveToDatabase RS("filedata")

    ' Commit the changes and close
    RS.Update
    RS.Close
    End If

    ' Output the file details to the browser
    Response.Write "File Uploaded: " & File.FileName & "<br>"
    Response.Write "Size: " & File.FileSize & " bytes<br>"
    Response.Write "Type: " & File.ContentType & "<br><br>"
    Next
    End If

    %>
     
    sinner8347, Dec 13, 2005 IP
  2. vectorgraphx

    vectorgraphx Guest

    Messages:
    545
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #2
    change the line

    Dim Uploader, File
    
    Code (markup):
    to read
    Dim Uploader, File, RS
    
    Code (markup):
    you need to dim all variables you create, since you have "option explicit" stated.

    HTH

    VG
     
    vectorgraphx, Dec 14, 2005 IP