Hey u all...
I have recently started using JS on ASP, but somewhere something went wrong: I could'nt compare two strings!!
My server's response is always invalid, even if ?t='s value is in the table.Code:<%@ LANGUAGE = JScript %> <html> <%var tester = (Request.QueryString("t")), oConn, oRs, filePath, r,i=1,b=false; filePath = Server.MapPath("pics.mdb"); oConn = Server.CreateObject("ADODB.Connection"); r = Server.CreateObject("adodb.recordset"); oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath); oRs = oConn.Execute("SELECT * From TableList"); while (!oRs.eof) { b=b||(tester==oRs("name")); Response.Write(oRs("name") + ": " + b + "<BR> " ); if (b) break; oRs.MoveNext();} oRs.close(); if (b){ Response.Write("<B>" +tester +" is valid!!</b>"); }else{ Response.Write(tester+ " is invalid!!");}%>
What should I do??




Reply With Quote