CreateParameter

rit01 · January 9th, 2006, 11:56 AM

Hi All

I am having a little CreateParameter problem...

What I am trying to do is create a parameter for a stored procedure using ADODB.Command's CreateParameter object (as detailed within ASP 3 book). The format I am using is:

Code:

Set objParam = objComm.CreateParameter("@paramName", adChar, adParamInput, 30)

objComm.Parameters.Append objParam1

Dim intValue

intValue = 1 or 2 or 3 or 4 or 5

objComm.Parameters("@paramName") = intValue

As you can see from the above, I am trying to add within this 1 parameter, a value that includes a series of numbers using an OR operator.

I have tried various ways and the closest I get is receiving the following error:

Application uses a value of the wrong type for the current operation.

Does anyone have any wisdom they are willing to share with me?

Warm Regards

Rit

Imar · January 9th, 2006, 01:11 PM

Hi Rit,

Does it help to convert intValue to a string first using CStr(intValue) ??

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

lameneural · February 2nd, 2006, 08:39 PM

Also happened to me, however, in your case, it is a datatype issue. Mine was of the same type - char/varchar. What I did was, I checked if Sizes of the fields in the table and the parameter I was trying to insert. The value I was inserting was longer than the size limit of the field. So I modified the limit just to fit the parameter.

Nothin.. Just sharing..