Simple problem pls help

[Pranit Saha]

I've saved the username and password in a table in sql server. Now the thing is, whenever user logs in. they provide the username and password as usual. and i've a select statement to validate the password as follows.

ResultSet rs = stat.executeQyery("select password from login where username ="+username);
The code gives us the password when the user exist in the table.
But it says "Invalid cursor index" whenever the username is not in table. How can i prevent this error and say "The username doesn't exist please sign-up"..
Thanks in advance.. pls help..

[David O'Meara]

if(rs.next())
{
    //user exists
}
else
{
    //user does not exist
}

Dave.

[Pranit Saha]

Dave,
Thanks a lot for ur kind help.. it works fine..
Pranit.

[Mahesh Rana]

Just to be on safe side,
always do
if(rs != null && rs.next())
{
//yes;
}
else
{
//no;
}

[Pranit Saha]

Yes deep i've already done this.. thanks for ur quote..
Pranit..