Does anyone know this error message

[bryant89]

Error Type:
ADODB.Parameter (0x800A0D5D)
Application uses a value of the wrong type for the current operation.
/NetworkForms/_ScriptLibrary/Recordset.ASP, line 979


I get this error message.
all of my dtc recordset values are set as varchars.
except in the stored procedure I do an insert of 7 varchars and then a select identity as int.

Could this int be the problem for the wrong type for current operation error

 

[computergeek]

Hi,

To get the new identity you don't need to define it as int.

Insert into table(col1,col2...)
values(@col1_parm, @col2_parm...)

select @@Identity as ID

Computergeek

 

[MerlinB]

Don't forget that the first parameter of a stored procedure is the return value, so

rsSpTest.setParameter 0, 'abc'

will fail. Try next parameter number instead...

rsSpTest.setParameter 1, 'abc'

Also dates sometimes have a habbit of breaking the parameters.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)

 

[jyothin]

Merlin,
I get this similar erro when i'm inserting date
oComd.Parameters("@TIMEOUT&quot.Value = nTimeOut