databases, usernames and passwords..

[benbacardi]

i'm very new to asp and this is probably very basic so bear with me!!!

i have a database holding usernames and passwords.

how do i check whether both a username and a passwords sent by "post" from a form are in the database in the same record? for example, a form with:

username:
password:

and then to check whether the username is there and whether the password matches it...

can anyone help? please?

[courtjester]

It's actually an SQL Statement... Where you connect to Table Where User = "Username"

Then you check if recordSet("Password") = Request.Form("Password") . Can ya get it from there? Or do you still need help?

[benbacardi]

as I said, i'm ver new - can u still give me help please? much appreciated

[Rob]

I think you are looking for something like this:-

Code: Select all

strSQL = "SELECT * FROM tblLoginInfo " _
		& "WHERE username='" & Replace(Request.Form("login"), "'", "''") & "' " _
		& "AND password='" & Replace(Request.Form("password"), "'", "''") & "';"

	Set cnnLogin = Server.CreateObject("ADODB.Connection")
	cnnLogin.Open("DRIVER={Microsoft Access Driver (*.mdb)};" _
		& "DBQ=" & Server.MapPath("login.mdb"))

	Set rstLogin = cnnLogin.Execute(strSQL)

	If Not rstLogin.EOF Then
		%>
		


		All the Good Stuff We Want to Hide
		</p>
		<%
	Else
		%>
		


		<font size="4" face="arial,helvetica">
		Login Failed - Please verify username and password.
		</font>
		</p>
		


		Try Again
		</p>
		<%
		'Response.End
	End If
'taken from asp101 http://www.asp101.com/samples/login.asp

Hope this helps.