January 14th, 2003, 01:39 PM
|
|
Contributing User
|
|
Join Date: Apr 2002
Location: The Great White North
Posts: 361
Time spent in forums: 58 m 50 sec
Reputation Power: 7
|
|
|
Application Uses a Value of the Wrong Type
I got the following error:
ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/Include/Authors.asp, line 71
Line 71 is the one with sphone:
Code:
Set cmd = Server.CreateObject("ADODB.Command")
With cmd
.activeconnection = objConn
.commandtext = "usp_SetAuthor"
.commandtype = &H0004 'this is adCmdStoredProcedure
.parameters("@Phone") = sPhone
.Execute , , adExecuteNoRecords
End With
I have set the datatype for Phone as varchar (12)
Searched aspfaq, but the suggestions were not helpful in this case. Any ideas? Thanks in advance.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
