D
David Lozzi
Hello,
I have a proc as displayed below. When I try to run it from ASP.NET I get an
error.
CREATE PROCEDURE [dbo].[cp_AddSession]
@SID as int,
@EID as int,
@DID as int,
@StartTime as varchar(10),
@Duration as int,
@Title as varchar(50),
@Location as varchar(50),
@Description as text,
@RegForm as varchar(50),
@SessID int OUTPUT
AS
INSERT INTO tblSessions
(intEID, intDay, strStartTime, intDuration, strTitle, strDescription,
strRoomLocation, strRegistrationForm)
VALUES
(@EID, @DID, @StartTime, @Duration, @Title, @Description, @Location,
@RegForm)
SELECT @SessID = @@IDENTITY
GO
Error: Procedure 'cp_AddSession' expects parameter '@SessID', which was not
supplied.
Thanks for the help!!
I have a proc as displayed below. When I try to run it from ASP.NET I get an
error.
CREATE PROCEDURE [dbo].[cp_AddSession]
@SID as int,
@EID as int,
@DID as int,
@StartTime as varchar(10),
@Duration as int,
@Title as varchar(50),
@Location as varchar(50),
@Description as text,
@RegForm as varchar(50),
@SessID int OUTPUT
AS
INSERT INTO tblSessions
(intEID, intDay, strStartTime, intDuration, strTitle, strDescription,
strRoomLocation, strRegistrationForm)
VALUES
(@EID, @DID, @StartTime, @Duration, @Title, @Description, @Location,
@RegForm)
SELECT @SessID = @@IDENTITY
GO
Error: Procedure 'cp_AddSession' expects parameter '@SessID', which was not
supplied.
Thanks for the help!!