Passing Parameters to a stored procedure

[Mayoor]

Im trying to execute the following section of code

If Request.QueryString("mode") = "update" then

Dim AvailableOption
For Each AvailableOption in Request.Form
If Request.form(AvailableOption) <> 0 then
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.ConnectionString = Application("oConStr")
myConn.Open

myConn.Execute "usp_UpdateRptGrpPrimDel " & AvailableOption & "," & Request.form(AvailableOption)
'Response.Write("usp_UpdateRptGrpPrimDel " & AvailableOption & "," & Request.form("AvailableOption"))
myConn.Close
End If
Next

End If

this then is supposed to be passing paramenters to this stored procedure.

CREATE PROCEDURE usp_UpdateRptGrpPrimDel

@lngRptGrpID int,
@strEMPID_PrimDel nvarchar(10)

AS

UPDATE tbl_RptGrps SET
strEMPID_PrimDel = @strEMPID_PrimDel
WHERE lngRptGrpID = @lngRptGrpID

GO


However when I check the database the change is not being made.

Can Anyone help!?

 

[Nevermoor]

One suggestion (assuming you are using SQL server), would be to go into query analyzer, paste the string you are trying to execute, and see what happens.

If it works from SQL server, we have a problem on the ASP side, and some sample data would be helpful for us.