hi there , i wanna check the data being enetered by the user in a form with that stored in the database , using the select command , i tried to do it like
Dim unam,p1
Dim DBcon, DBstr, sel
unam=request.form("thename")
p1=request.form("thepass")
Set DBcon = Server.CreateObject("ADODB.Connection")
DBstr = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(".") & "\eSwin.mdb"
DBcon.Open DBstr
sel="select username from members where username='unam'"
DBcon.Execute sel
DBcon.Close
Set DBCon = Nothing
response.write sel
