Arguments are of the wrong type, are out of acceptable range, or are in conflict with

[Raluk]

Hello,

Please help me. I'm trying to call a sql procedure for each record in a recordset.
I'm getting this error :Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another and because my close to zero experience i don't know what's wrong. Thank you

Do while not rsResultsDetail.EOF
 
   Set cmd = Server.CreateObject("ADODB.Command")
   cmd.ActiveConnection = conn
   cmd.CommandText = "Delete_Nonconformities"
   cmd.CommandType =adCmdStoredProc
   cmd.Parameters.Append cmd.CreateParameter("@P_NONCONFORMITY_ID", adInteger, adParamInput) 
   cmd.Parameters("P_NONCONFORMITY_ID") =rsResultsDetail("NonConformityID")
   cmd.Execute
 
   rsResultsDetail.MoveNext
 
loop

[jhardman]

Is the error coming from the sql client or from IIS (an ASP error)?

[Raluk]

Well.... i don't think this is the problem , because it works if i do something like this:

sqlDelteNonconformity = "delete from Nonconformity where ID=" & rsResultsDetail("NonConformityID")
set rsDeleteNonconformity = Server.CreateObject("ADODB.Recordset")
rsDeleteNonconformity.Open sqlDelteNonconformity ,conn,1,2

[jhardman]

Is this error returned from the SQL client? I can't tell from your post, but it sounds like you have not sent the parameters correctly. For example, the stored procedure might be expecting an integer, but you are actually sending a string. Or perhaps it is expecting another parameter.

Jared