Link to home
Start Free TrialLog in
Avatar of gianitoo
gianitoo

asked on

ADODB.Command error '800a0d5d'

i am getting this error
ADODB.Command error '800a0d5d'

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

/administratorsteammanagerupdatescore3.asp, line 74

my sp   in line 74  
hometeamreport.Parameters.Append hometeamreport.CreateParameter("@chino", 200, 1,10,hometeamreport__chino)

@chino is a number but in my table i have the field datatype as  varchar
Avatar of hongjun
hongjun
Flag of Singapore image

Try this

hometeamreport.Parameters.Append hometeamreport.CreateParameter("@chino", 200, 1, 255, CStr(hometeamreport__chino))
Avatar of gianitoo
gianitoo

ASKER

this is what my sp looks like...i went to view the table for springgameresults  and all of those fields are   data type  int

CREATE PROCEDURE hometeamscore


@varid varchar (10), @chino varchar (100), @scorehome varchar (10), @scorevisit varchar (10), @phome varchar (10), @winh varchar (10), @tieh varchar (10), @lossh varchar (10), @gameplayed int,
@chola varchar (100),@pvisit varchar (10),@winv varchar (10),@tiev varchar (10),@lossv varchar (10),@noshow varchar (10)
as

SET NOCOUNT ON

INSERT INTO dbo.springgameresults (juego, idofteam, goalsinfavor, goalsagainst, points, win, tie, loss, gameplayed)
VALUES
(@varid, @chino, @scorehome, @scorevisit, @phome, @winh, @tieh, @lossh, @gameplayed)

INSERT INTO dbo.springgameresults (juego, idofteam, goalsinfavor, goalsagainst, points, win, tie, loss, gameplayed)  
VALUES(
@varid, @chola,@scorevisit,@scorehome,@pvisit,@winv,@tiev,@lossv,@gameplayed)

UPDATE dbo.ScheduleMatchupsByLine
SET  homescore=@scorehome, visitscore=@scorevisit,statushome=2,noshow=noshow  WHERE Game =@varid

SET NOCOUNT OFF
GO
ASKER CERTIFIED SOLUTION
Avatar of kevp75
kevp75
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial