IF (@MyRowCount = 1 ) 
BEGIN
SET @err = 'Password Change is a Success!' 
SELECT @err as lblerror
RETURN
END

IF (@MyRowCount = 0 ) 
BEGIN
SET @err = 'Unable to change password! Make sure that you have Supplied the correct information!' 
SELECT @err as lblerror
RETURN
END

SET @err = 'Unable to change password! Make sure that you have Supplied the correct information!' 
SELECT @err as lblerror

SELECT 'Unable to change password! Make sure that you have Supplied the correct information!' AS lblerror

quote:

---

Originally posted by erikkl2003

Hello sqlers!,

i am in need for someone to point out to me how to handel if i receive an error durning this update

==================================================

I had this little segment in the code and this will not produce desired results.. So i took it out... all of the other checks work fine. but when i add this little snipet sql bypased the othe checks..

Any comments that might help me better understand how to implement this would be very nice... i am open to all comments about this pattern that i am working with..

thanks alot
erik


IF EXISTS (SELECT Email FROM Users WHERE Email = @Admin_Email AND UserType = 'Admin')

BEGIN
UPDATE Users
SET [Password] = @NewUserPassword
Where (Email = @UserEmail And UserID = @UserID)

SELECT @err = @@Error --Check for Update Error
SELECT @rc = @@ROWCOUNT

IF ( @err <> 0 )
BEGIN
GOTO PROBLEM
END
---------------------------------------------------------

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER PROCEDURE Admin_ReSet_UserPassword

@Admin_Email Varchar (200), /*Admin Check */
@UserID INT,
@UserEmail VARCHAR (200),
@NewUserPassword Binary (24)

AS
DECLARE @err Varchar (200), @rc as Int

IF EXISTS (SELECT Email FROM Users WHERE Email = @Admin_Email AND UserType = 'Admin')

BEGIN
UPDATE Users
SET [Password] = @NewUserPassword
Where (Email = @UserEmail And UserID = @UserID)

IF (@@ROWCOUNT = 1 )
BEGIN
SET @err = 'Password Change is a Success!'
SELECT @err as lblerror
RETURN
END

IF (@@ROWCOUNT = 0 )
BEGIN
SET @err = 'Unable to change password! Make sure that you have Supplied the correct information!'
SELECT @err as lblerror
RETURN
END
END

ELSE

quote:

---

I dont think this else is required if no rows are updated then it will be return 0

---

BEGIN
SET @err = 'Admin Credentials do not Match!'
SELECT @err as lblerror
RETURN
END

PROBLEM:
IF (@err <> 0 )

quote:

---

It should be like this If (@@Error <> 0)

---

BEGIN
SET @err = 'There was an error during the update! Please try Again, and if the problem persists please contact the SuperCenter.'
SELECT @err as lblerror
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO



If you wait untill tomorrow; you will have no future.

---