I've been searching all over the net and forums trying to find an answer to this problem. But I can't seem to figure out what the problem is. I keep recieving this error.
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
vdateUsr.asp, line 47
Here is the code:
' execute sql and open as recordset
sqlStr = "Select * From tUsers where username = '" _
& Request.Form("username") & "' and password = '" & Request.Form("password") & "'"
' Opens the returned values from the SQL as a recordset, ready for iteration by ASP
set rcSet = cnStr.Execute(sqlStr) // And this is line 47
I have tried checking the delimiters, spacing, everything that I could find a possible problem with, but have still had no luck. However I'm still very new to this and could be on the wrong track totally.