Re: Validate logins with ASP, MS Access and Cookies error
- From: "Mike Brind" <paxtonend@xxxxxxxxxxx>
- Date: 15 Apr 2006 09:37:50 -0700
malcolm wrote:
Hi, while trying to validate username and password on login form I am
presented with the following error message
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/vdateUsr.asp, line 53
The 2 fields within the database are text fields (UID) and (PWD) these are
spelt correctly!
<snip>
sqlStr = "Select * From tblusers where username = '" _
& Request.Form("UID") & "' and password = '" & Request.Form("PWD") & "'"
No - they're not spelt correctly. In your SQL statement you refer to
two fields called username and password, yet you said they are called
UID and PWD. Which is correct?
--
Mike Brind
.
- Follow-Ups:
- References:
- Validate logins with ASP, MS Access and Cookies error
- From: malcolm
- Validate logins with ASP, MS Access and Cookies error
- Prev by Date: Re: Validate logins with ASP, MS Access and Cookies error
- Next by Date: Re: Validate logins with ASP, MS Access and Cookies error
- Previous by thread: Re: Validate logins with ASP, MS Access and Cookies error
- Next by thread: Re: Validate logins with ASP, MS Access and Cookies error
- Index(es):
Relevant Pages
|
