Stored Proc not Outputting

[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 , strRegistration Form)
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!!

--
David Lozzi
Web Applications Developer
dlozzi@(remove-this)delphi-ts.com

[Peter Rilling]

Did you supply the parameter in your code?

"David Lozzi" <Da********@nos pam.nospam> wrote in message
news:ev******** *******@TK2MSFT NGP11.phx.gbl.. .

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 , strRegistration Form)
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!!

--
David Lozzi
Web Applications Developer
dlozzi@(remove-this)delphi-ts.com

[Karl Seguin]

Also, if you are only returning 1 parameters, I'd use ExecuteScalar and
simply select the value ala:

object o = command.Execute Scalar();
if (o != null && o!= DBNull.Value)
{
return Int32.Parse(o);
}

and simply do SELECT @@IDENTITY in your stored procedure.

This will return 1 value (the identity), which is exactly what ExecuteScalar
is there to handle.

On a side note, in SQL Server 2000, use SCOPE_IDENTITY( ) instead of
@@IDENTITY, else you'll eventually run into trouble:
http://weblogs.asp.net/rosherove/arc.../13/37217.aspx

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
http://openmymind.net/redirector.aspx?documentId=51 - Learn about AJAX!

"Peter Rilling" <pe***@nospam.r illing.net> wrote in message
news:eI******** ********@TK2MSF TNGP09.phx.gbl. ..

Did you supply the parameter in your code?

"David Lozzi" <Da********@nos pam.nospam> wrote in message
news:ev******** *******@TK2MSFT NGP11.phx.gbl.. .

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 , strRegistration Form)
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!!

--
David Lozzi
Web Applications Developer
dlozzi@(remove-this)delphi-ts.com

[Patrick.O.Ige]

As Peter adviced and the error says:-
Error: Procedure 'cp_AddSession' expects parameter '@SessID', which was
not supplied.
You can also look at this article by Scott here at :-
http://aspnet.4guysfromrolla.com/articles/062905-1.aspx
For a Ref
Patrick
"David Lozzi" <Da********@nos pam.nospam> wrote in message
news:ev******** *******@TK2MSFT NGP11.phx.gbl.. .

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 , strRegistration Form)
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!!

--
David Lozzi
Web Applications Developer
dlozzi@(remove-this)delphi-ts.com