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.
/administratorsteammanager updatescor e3.asp, line 74
my sp in line 74
hometeamreport.Parameters. Append hometeamreport.CreateParam eter("@chi no", 200, 1,10,hometeamreport__chino )
@chino is a number but in my table i have the field datatype as varchar
ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/administratorsteammanager
my sp in line 74
hometeamreport.Parameters.
@chino is a number but in my table i have the field datatype as varchar
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,@scoreh ome,@pvisi t,@winv,@t iev,@lossv ,@gameplay ed)
UPDATE dbo.ScheduleMatchupsByLine
SET homescore=@scorehome, visitscore=@scorevisit,sta tushome=2, noshow=nos how WHERE Game =@varid
SET NOCOUNT OFF
GO
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,@scoreh
UPDATE dbo.ScheduleMatchupsByLine
SET homescore=@scorehome, visitscore=@scorevisit,sta
SET NOCOUNT OFF
GO
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
hometeamreport.Parameters.