Problem passing parameter to stored procedure

[mako]

Hi, I'm having some problems with passing a parameter to a stored procedure. Any help is greatly appreciated.

My code :

adCmdStoredProc = 4
adParamReturnValue = 4
adParaminput = 1
adParamOutput = 2
adInteger = 3
adVarChar = 200

Set Cmd = Server.CreateObject("ADODB.Command&quot
Set Cmd.ActiveConnection = Conn

Cmd.CommandText = "WebRptGetProduct"
Cmd.CommandType = adCmdStoredProc
Cmd.Parameters.Append Cmd.CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue, 4)
Cmd.Parameters.Append Cmd.CreateParameter("@IssNo", adInteger, adParamInput, , 1)
Set rsProduct = Cmd.Execute


I get this error message:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E07)
Error converting data type int to smallint.

 

[shiggyshag]

HI

Try

Cmd.Parameters.Append Cmd.CreateParameter("@IssNo", adSmallInt, adParamInput, 2, 1)

Cheers

 

[mako]

Thanks but I still get the same error. :-/
Wonder what's wrong???