Obtain data from database .mdb
Hi experts, codes below are working except on obtaining UserName. This code refuses to obtain the UserName.
"Session("Allow") = UserName. And I Don't know which part of the codes are wrong. Any help please!
rs.Open "Select UserName, iPassword, TelNumber from MyUsers where UserName='" & uname & "' And iPassword='" & pswd & "'", conn
with rs
If not .BOF = True And not .EOF = True Then
Session("Allow") = "Hello" & " " & UserName & "!"
else
Session("Allow") = "Hello Visitors!"
End If
end with
"Session("Allow") = UserName. And I Don't know which part of the codes are wrong. Any help please!
rs.Open "Select UserName, iPassword, TelNumber from MyUsers where UserName='" & uname & "' And iPassword='" & pswd & "'", conn
with rs
If not .BOF = True And not .EOF = True Then
Session("Allow") = "Hello" & " " & UserName & "!"
else
Session("Allow") = "Hello Visitors!"
End If
end with
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
My pleasure, glad to help :)
If you don't mind me asking, what kind of project are you working on? Not too many folks these days do classic asp work (why I don't know as it's such a versatile language) so I'm always curious to meet fellow devs :)
If you don't mind me asking, what kind of project are you working on? Not too many folks these days do classic asp work (why I don't know as it's such a versatile language) so I'm always curious to meet fellow devs :)
ASKER
Hi Monty, I actually not familiar what asp i am using right now whether it is classic or not. It was happened that I was not able to run .php on my pc. So, one of the experts gave me a solution using asp to be able to save and connect the data. I am beginner of this project where I am just only vb6 programmer. What I am trying to do now is that only a practice because I really love programming. Any advice is greatly appreciated! Thank you!
ASKER