Re: Validate logins with ASP, MS Access and Cookies error

UID and PWD are the 2 fields in my database that hold the information.

I have now changed the code

"Mike Brind" <paxtonend@xxxxxxxxxxx> wrote in message
news:1145119070.271743.314040@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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



.

Relevant Pages

  • Re: Bad user name still allows entry
    ... When I double-clicked the database to open it ... opened as long as the pwd was correct. ... It doesn't prompt me for uid or pwd. ... the db opens no matter what value I use for jobUID. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Software implementing Gentech Genealogical Data Model
    ... some objects with a UID (unique identifier) to replace the primary ... database key of the original model:  "A UID is only required to be ... numeric identifier seems much, much better. ...
    (soc.genealogy.computing)
  • Re: Software implementing Gentech Genealogical Data Model
    ... implements the Gentech Genealogical Data Model, ... some objects with a UID to replace the primary ... database key of the original model: "A UID is only required to be ...
    (soc.genealogy.computing)
  • Re: caching problem
    ... >I am new to asp.net I coded simple login form and placed two textboxes and ... I want to verify the uid and pwd in my databasewith the user ... You'll have to edit, compile, and then refresh the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Software implementing Gentech Genealogical Data Model
    ... implements the Gentech Genealogical Data Model, ... some objects with a UID to replace the primary ... database key of the original model: "A UID is only required to be ... expect clashes between one databases' IDs and another databases'. ...
    (soc.genealogy.computing)