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

Expand|Select|Wrap|Line Numbers

 
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

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

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

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

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

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about