I am using a stored procedure to insert records into a database. In the sp, I&#039m specifing the parameter @Reason.<BR><BR>The problem is, the value for @Reason is an array of items. How can I set an @Reason parameter for every item in the array? I&#039ve tried the following:<BR><BR>&#060;%<BR>cmd.CommandText = "sp_AddInfo"<BR> cmd.CommandType = adCmdStoredProc<BR> cmd.ActiveConnection=application("connstring") <BR><BR>For each strReas in RArray<BR> &#039ReasonID<BR> Set param = cmd.CreateParameter("ReasonID", adInteger, adParamReturnValue, 4)<BR> cmd.Parameters.Append param<BR> <BR> &#039Reason <BR> Set param = cmd.CreateParameter("Reason", adVarChar, adParamInput, 250, strReas)<BR> cmd.Parameters.Append param <BR> <BR> Next <BR><BR>cmd.execute %&#062;<BR><BR>but I still get the error that too many arguements were supplied. How can I set the parameter equal to an indeterminate amount of values?<BR><BR>Thanks for all help.