User Login

[Ahmult]

<%
vName = Request.Form("name");
vPwd = Request.Form("pwd");
vConnString = Server.MapPath("/group") + "\\_db\\user.mdb";
vRS = Server.CreateObject("ADODB.Recordset");
vRS.ActiveConnection = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" +
vConnString;
vRS.Source = "SELECT * FROM reg";
vRS.Open();
%>

When the user login, the sql only can search for the 1st line. How can we do
the code so it can search for the next user?

I tried to use this code. My database is called reg and has 3 parameter. id,
username and pwd
How to solve? And one more thing is that it is made by javascript

Any help is appreciate

[goerdie_uk]

you need to loop throught the recordset , if youre using DW , try using repeat region to see how it works - if not look at the BOF and EOF parameter in ASP