How do-Dee-Clare.... sos
-
if the if exists ( DOES NOT EXISTS)??
Hello,
my querry is working fine until i added this piece of code.
=============================================
i am lost on the declare part..
END
ELSE
BEGIN
DECLARE @OrderID INT, @OrderDT DATETIME, @ShipDT DATETIME, @TrackingNum Varchar (30), @Note (200), @ShippingCompany Varchar (20),@OrderStatusDescr Varchar (30)
SET @OrderID = 0
SET @OrderDT = '00/00/0000 0:00:00 AM'
SET @ShipDT = '00/00/0000 0:00:00 AM'
SET @TrackingNum = 'NONE'
SET @ShippingCompany = 'NONE'
SET @OrderStatusDescr = 'User Has no Orders on File'
SELECT @OrderID as OrderID, @OrderDT as OrderDT, @ShipDT as ShipDT, @TrackingNum as TrackingNum, @ShippingCompany as ShippingCompany, @OrderStatusDescr as OrderStatusDescr
END
END
END
==============================================
What i am doing is trying to send some data.. reather than no data if no exists in the database based on the restrictions that are suppied by the parameters.
My goal here is to cut down on vb.net code by at least sending enough data to send a reader back to the ui.... so that i do not have to deal with exception.... and this will make better for a standard error or (User has no orders .. bla .. bla)
Can someone please help me finish this...???
thanks alot,
erik.
=========================================================================
ALTER PROCEDURE Admin_SelectUser_Orders
@Admin_Email Varchar (200), /*Admin Check */
@Admin_FName Varchar (30), /*Admin Check */
@Admin_UserType Varchar (20), /*Admin Check */
@user-id int,
@UserType Varchar (30),
@LastName Varchar (30),
@Email Varchar (200)
As
BEGIN
IF EXISTS (SELECT Email, FirstName, UserType FROM Users
WHERE Email = @Admin_Email AND
FirstName = @Admin_FName AND
UserType = @Admin_UserType)
BEGIN
SELECT Orders.OrderID AS OrderID, Orders.OrderDT , Orders.ShipDT, Orders.TrackingNum, Orders.Note,
Orders.ShippingCompany , OrderStatus.OrderStatusDescr ,
PaymentType.PaymentDescr
FROM Orders INNER JOIN
Users ON Orders.UserID = Users.UserID INNER JOIN
PaymentType ON Orders.PaymentCD = PaymentType.PaymentCD INNER JOIN
OrderStatus ON Orders.OrderStatusCD = OrderStatus.OrderStatusCD
WHERE (Users.UserID =@UserID AND Users.Email = @Email AND Users.LastName = @LastName AND Users.UserType = @UserType)
END
ELSE
BEGIN
DECLARE @OrderID INT, @OrderDT DATETIME, @ShipDT DATETIME, @TrackingNum Varchar (30), @Note (200), @ShippingCompany Varchar (20),@OrderStatusDescr Varchar (30)
SET @OrderID = 0
SET @OrderDT = '00/00/0000 0:00:00 AM'
SET @ShipDT = '00/00/0000 0:00:00 AM'
SET @TrackingNum = 'NONE'
SET @ShippingCompany = 'NONE'
SET @OrderStatusDescr = 'User Has no Orders on File'
SELECT @OrderID as OrderID, @OrderDT as OrderDT, @ShipDT as ShipDT, @TrackingNum as TrackingNum, @ShippingCompany as ShippingCompany, @OrderStatusDescr as OrderStatusDescr
END
END
END
Dam again!
-
-
someone just pointed that out to me...
thanks alot for the help!
erik
Dam again!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply