ورود

View Full Version : error :No value given for one or more required parameters



pranses_smt
دوشنبه 27 آذر 1391, 09:35 صبح
سلام من این کد رودر یکی از صفحاتم نوشتم ولی این error مشاهده میشه:
No value given for one or more required parameters
کد اینه:



<%
Set Conn = Server.CreateObject("ADODB.Connection")
//strcon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & server.mappath("ado\LoginWeb.accdb") & ";"
conn.Provider="Microsoft.ACE.OLEDB.12.0"
conn.Open( Server.Mappath("ado\LoginWeb.accdb"))
//**set rs = Server.CreateObject("ADODB.recordset")
//strsql= "Select UserName,PassWord from Login where username="' & Request.Form("username") & "' And Password = '" & Request.Form("password") & "'"
strsql= "Select [username],[password] from Login where username=" & Request.Form("username")
// & " And password = " & Request.Form("password")

set rs = conn.Execute (strsql)
If (not rs.BOF) and (not rs.EOF) then
response.Session ("name") = rs.Fields("username")
Response.Write("username")
Response.Session("name").Expires = Date + 1

Response.Redirect "Index.html"
else
Response.Redirect "aboutus.html"
end if

rs.close
set rs = nothing
conn.close
set conn = nothing
%>


ممنون می شم کمکم کنید