Support forums » Products » ASP Uploader » Re: How to validate a file being uploaded across a SQL db?

Re: How to validate a file being uploaded across a SQL db?

  •  12-26-2012, 11:07 AM

    Re: How to validate a file being uploaded across a SQL db?

    Reply Quote

    Hi Ken,

     

    Hope you had a great Christmas. Thanks your reply.

     

    However, this still does not solve the issue at hand.

     

    1. <%    
    2.                Set AdoCon=Server.CreateObject("ADODB.Connection")    
    3.                Set AdoRec=Server.CreateObject("ADODB.Recordset")    
    4.                AdoCon.ConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=*******;Initial Catalog=AFDDB_DEVY;Data Source=MOMENTUMTEST"    
    5.                AdoCon.Open    
    6.                AdoRec.Open "Select Custid from APPLICATION",AdoCon    
    7.                str=AdoRec.GetString()    
    8.                  %>    
    9.    
    10.    
    11.                for (var i = 0; i < files.length; i++) {     
    12.                var name = files[i].FileName;     
    13.                if (str==name) {     
    14.                    alert(files[i].FileName);    
    15.                    'files[i].Cancel();     
    16.                    }     
    17.                }      
    18.                    
    19.                    
    20.                  <%    
    21.                AdoRec.close    
    22.                AdoCon.close    
    23.                set AdoRec = Nothing    
    24.                set AdoCon = Nothing    
    25.                    %>     
     

     

    I still am unable to validate across the database with the above code.

    For some reason str variable does not want to work against the name variable.

     

    Thanks,

    Khan 

     
View Complete Thread