Too few parameters. Expected 1
Jeg får følgende fejl:Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/login/opret.asp, line 77
Koden ser således ud:
<%
select case request("mode")
case "opret"
set connect = server.createobject("ADODB.Connection")
Connect.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("../butik.mdb")
Set rs = Connect.Execute("SELECT email,brugernavn FROM kunder WHERE email = '" & request.form("email") & "' OR brugernavn = '" & request.form("brugernavn") & "'")
if rs.eof then
SQL = "insert into kunder (navn,vej,byen,postnummer,telefon,mobil,email,brugernavn,password,levering,dato) Values ('" & request.form("navn") & "','" & request.form("vej") & "','" & request.form("byen") & "','" & request.form("postnummer") & "','" & request.form("telefon") & "','" & request.form("mobil") & "','" & request.form("email") & "','" & request.form("brugernavn") & "','" & request.form("password") & "','" & request.form("levering") & "',[" & now() & "])"
Connect.Execute(SQL)
set connect = nothing
response.redirect "index.asp?mode=nybruger"
else
response.write "Der findes en bruger med samme brugernavn eller e-mail"
end if
end select
%>
