Posted on 2007-11-29
I have the select statement below my following vb code in a called stored procedure...
How do I get my vb code to do something based on what's returned...
I don't know what to do when the 'Incorrect Email' or "Incorrect password" is returned.
If dR.HasRows Then
If dR("ttlLogins") < 3 Then
SQL Server code.
IF NOT EXISTS (SELECT * FROM dbo.tblUsers WHERE Email = @Email)
RETURN 'Incorrect Email'
IF NOT EXISTS (SELECT * FROM dbo.tblUsers WHERE Email = @Email AND UserPassword = @UserPassword)
RETURN 'Incorrect Password'
from dbo.tblUsers where email = @Email and UserPassword = @UserPassword