Link to home
Create AccountLog 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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer