We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

ADODB.Command error '800a0d5d'

gianitoo
gianitoo asked
on
Medium Priority
519 Views
Last Modified: 2012-08-13
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
Comment
Watch Question

Commented:
Try this

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

Author

Commented:
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
Commented:
change:
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)

to:
CREATE PROCEDURE hometeamscore


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

the sp datatypes need to mathc the data types of the table

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.