I use stored procedures all the time, but now I'm getting this error. After I insert a Stored Procedure in my program, this error comes up:

"Please edit the 'rs_AllCategories' recordset and set the type for the 'ClientID' parameter."

This happens on all the recordsets I create (with the appropriate recordset and parameter names of course).

It looks like the way the stored proc is executed has changed recently. Here's my code... What is the able error asking me to change???

Thanks!


<%
Dim rs_AllCategories__ClientID
rs_AllCategories__ClientID = "0"
If (Session("ClientID" <> "" Then
rs_AllCategories__ClientID = Session("ClientID"
End If
%>
<%
Dim rs_AllCategories
Dim rs_AllCategories_cmd
Dim rs_AllCategories_numRows

Set rs_AllCategories_cmd = Server.CreateObject ("ADODB.Command"
rs_AllCategories_cmd.ActiveConnection = MM_conn_MainData_STRING
rs_AllCategories_cmd.CommandText = "{call dbo.Articles_ClientUsedCategoryList(?)}"
rs_AllCategories_cmd.Prepared = true
rs_AllCategories_cmd.Parameters.Append rs_AllCategories_cmd.CreateParameter("param1", -1, 1, -1, rs_AllCategories__ClientID) ' N/A

Set rs_AllCategories = rs_AllCategories_cmd.Execute
rs_AllCategories_numRows = 0
%>





Phil Grimpo
Executive Director
Inspirmedia