1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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