Can someone please let me know why I'm getting "Procedure or function tester has too many arguments specified" from my asp page when trying to call a stored procedure? This is driving me crazy, Im copying this example straight from an ASP book.
Stored Procedure:
CREATE PROCEDURE tester @v_id_in int, @v_status int OUTPUT
AS
select @v_status = count(1) from test where id = @v_id_in
ASP call:
rs.ActiveConnection = conn '(conn is a db connection)
rs.CommandText = "dbo.tester"
rs.CommandType = adCmdStoredProc
rs.Parameters.Append rs.CreateParameter("@v_id_in",adInteger,adParamInput,50,1)
rs.Parameters.Append rs.CreateParameter("@v_status",adInteger,adParamOutput)
rs.Execute
intNum = rs.Parameters("@v_status")
Thanks 4 any help.
Stored Procedure:
CREATE PROCEDURE tester @v_id_in int, @v_status int OUTPUT
AS
select @v_status = count(1) from test where id = @v_id_in
ASP call:
rs.ActiveConnection = conn '(conn is a db connection)
rs.CommandText = "dbo.tester"
rs.CommandType = adCmdStoredProc
rs.Parameters.Append rs.CreateParameter("@v_id_in",adInteger,adParamInput,50,1)
rs.Parameters.Append rs.CreateParameter("@v_status",adInteger,adParamOutput)
rs.Execute
intNum = rs.Parameters("@v_status")
Thanks 4 any help.