Return Output Parm

The stored Procedure I am using





CREATE PROCEDURE GetUserID


(


@Email nvarchar(100),


@Password nvarchar(50),


@UserID int OUTPUT


)


AS


SET @UserID = (SELECT fldResourceID


FROM tblResources


WHERE fldEmail = @Email AND fldPassword = @Password)





GO





The Code Behind to call it.





Dim intUserID As Integer = 0


Dim strConnectionString As String = dbConnect()


Dim objConnection As SqlConnection = New SqlConnection(strConnectionString)


objConnection.Open()





Dim objCmd As SqlCommand = New SqlCommand("EXEC GetUserID '" & strEmail & "','" & strPassword & "', " & intUserID, objConnection)





intUserID = objCmd.ExecuteScalar()





objCmd = Nothing


objConnection = Nothing





Return intUserID





However nothing is returned from the objCmd.ExecuteScalar line. Can anyone help me out here. All I need it to return is a single value. Thanks