Too many arguments specified?

[ChopinFan]

I am trying to execute a simple select query in an ADP file via code and I’m getting an error message saying the sproc has “too many arguments specified”. It’s a very simple query and I don’t see what I’m doing wrong. "Com" is my command object variable and "Con" is my connection object variable, both of which are working fine. I've searched the FAQs but found nothing. Thanks!

Code:

With Com
.ActiveConnection = Con
.CommandType = adCmdStoredProc
.CommandText = "dbo.MyProcedureName"
.Parameters.Append .CreateParameter("@Parameter", adVarChar, adParamInput, 9, Trim(FormField.Value))
End With
Set MyRecordset = Com.Execute


Sproc:

CREATE PROCEDURE dbo.MyProcedureName

@Parameter varchar(9)

AS

SELECT Field
FROM dbo.Table
WHERE (Field = @Parameter)

GO

 

[jbenson001]

You are appending a parameter. If the code is called more than once, won't another parameter be added to the collection? Try removing any parameters first.

 

[ChopinFan]

I'm not quite sure I follow. I use the same code layout in many cases where information is retrieved to populate recordsets or add/update data in the database and it works without a problem. I don't see what I'm doing differently in this case.

 

[jbenson001]

Well then I think you need to post this in the appropriate forum, VBS I am guessing.