calling Stored Procedures

I am trying to call some stored procedures that reside on a database, and am receive the same error in IE.
THe error reads: Must declare variable '@UserID'
@UserID is one of the parameters passed into to stored procedure, and I do make reference to it in asp by calling a particular UserID using cmd.Parameters.
Can anyone fix my problem??

[Johnny101]

it sounds like the stored procedure itself is generating this error. which means that it might not be declared correctly. Look at the following code and compare to your own

'stored procedure code:

CREATE PROCEDURE boc_GetAssetInfo (
@OrderLineID INT )

as

BEGIN

'your SQL code here...

END




then in code, i would call this proc like this:

set rs = Server.CreateObject("ADODB.Recordset")
set Cmd = Server.CreateObject("ADODB.Command")

With Cmd
.ActiveConnection = "Your Connection Object or string Here"
.CommandText = "boc_GetAssetInfo"
.CommandType = adCmdStoredProc
.CommandTimeout = 600
.Parameters.Append Cmd.CreateParameter("OrderLineID", adInteger, adParamInput)
.Parameters("OrderLineID") = iOrderLineID
End With

set rs = Cmd.Execute




hope this helps,

John


John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org