November 17, 2005 at 1:15 pm
I would like to compare the admin information first before i allow the select statement to complete or excute.
can someone please help me with this?
erik..
ALTER PROCEDURE AdminSystem_SelectConsumerInformation
@Admin_Email Varchar (200), /*Admin Check */
@Admin_FName Varchar (30), /*Admin Check */
@Admin_UserType Varchar (20), /*Admin Check */
@user-id INT,
@UserEmail as Varchar (200)
AS
Select Email, FirstName, UserType
From Users
Where Email = @Email
If (@@Error = 0) then
If Email = @Admin_Email AND FirstName = @Admin_FName AND UserType = @Admin_UserType
AND
IF (@@Error = 0) THEN
Select UserID,
UserType,
FirstName,
LastName,
Address1,
Address2,
City,
Zip,
WkPhone,
HmPhone,
Fax,
Title,
Note,
StateCD,
CountryCD,
ActiveInd,
From Users
WHERE UserID = @user-id
And @UserEmail = @UserEmail
Dam again!
November 17, 2005 at 1:20 pm
add this part corrently
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Where Email = @Admin_Email
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
ALTER PROCEDURE AdminSystem_SelectConsumerInformation
@Admin_Email Varchar (200), /*Admin Check */
@Admin_FName Varchar (30), /*Admin Check */
@Admin_UserType Varchar (20), /*Admin Check */
@user-id INT,
@UserEmail as Varchar (200)
AS
Select Email, FirstName, UserType
From Users
Where Email = @Admin_Email
If (@@Error = 0) then
If Email = @Admin_Email AND FirstName = @Admin_FName AND UserType = @Admin_UserType
AND
IF (@@Error = 0) THEN
Select UserID,
UserType,
FirstName,
LastName,
Address1,
Address2,
City,
Zip,
WkPhone,
HmPhone,
Fax,
Title,
Note,
StateCD,
CountryCD,
ActiveInd,
From Users
WHERE UserID = @user-id
And @UserEmail = @UserEmail
Dam again!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply