'Verify user information in the database
strSQL = "SELECT membername, memberemail, memberpassword FROM memberinfo WHERE &_
membername = CStr(Request.Form("txtFirstName")) & _
memberemail = CStr(Request.Form("txtEmail")) & _
memberpassword = CStr(Request.Form("txtPassword"));"
Set objConn = Server.CreateObject("ADODB.Connection")
Set objCmd = Server.CreateObject("ADODB.Command")
Set objCmd.ActiveConnection = objConn
objCmd.CommandText = strSQL
objCmd.CommandType = adCmdText
'Check for database errors
I'm tring to verify users login info from a form to my access database, i tried using stored procedures but it wasn't working for me.. i'm reading the wrox "beginning asp databases" (not .net):)
anyway,,, i'm a little confused on syntax with the vb
below is what i tried.. and it didn't work:(
any help would be great!
'Check for empty recordset which indicates user information
'was not found
If objRS.EOF or objRS.BOF Then
Session("ErrorMessage") = "No record found - Please ensure all information was entered correctly"
Session("ErrorMessage") = Empty