webdork
asked on
Store Procedure Error
Why am I getting this error:
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."
At this line:
cmd.Parameters.Append cmd.CreateParameter("PID", adInteger, adParamInput)
SP++++++++++++++++++++++++ +++++++++
CREATE procedure sp_GetProduct
@PID int
AS
Begin
select * from products where productid = @PID
end
GO
ASP+++++++++++++++++++++++ ++++++++++ ++++++++++ +
Set conn = Server.CreateObject("ADODB .Connectio n")
conn.Open "XXX", "XXX", "XXXXXXXX"
Set cmd = Server.CreateObject("ADODB .Command")
Set cmd.ActiveConnection =conn
Const adCmdStoredProc = 4
cmd.Parameters.Append cmd.CreateParameter("PID", adInteger, adParamInput)
cmd("PID") = 100
cmd.Execute
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."
At this line:
cmd.Parameters.Append cmd.CreateParameter("PID",
SP++++++++++++++++++++++++
CREATE procedure sp_GetProduct
@PID int
AS
Begin
select * from products where productid = @PID
end
GO
ASP+++++++++++++++++++++++
Set conn = Server.CreateObject("ADODB
conn.Open "XXX", "XXX", "XXXXXXXX"
Set cmd = Server.CreateObject("ADODB
Set cmd.ActiveConnection =conn
Const adCmdStoredProc = 4
cmd.Parameters.Append cmd.CreateParameter("PID",
cmd("PID") = 100
cmd.Execute
ASKER
Revised ASP code still error
ASP+++++++++++++++++++++++ ++++++++++ ++++++++++ +
Set conn = Server.CreateObject("ADODB .Connectio n")
conn.Open "XXX", "XXX", "XXXXXXXX"
Set cmd = Server.CreateObject("ADODB .Command")
Set cmd.ActiveConnection =conn
Const adCmdStoredProc = 4
cmd.CommandText = " sp_GetProduct "
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("PID", adInteger, adParamInput)
cmd("PID") = 100
cmd.Execute
ASP+++++++++++++++++++++++
Set conn = Server.CreateObject("ADODB
conn.Open "XXX", "XXX", "XXXXXXXX"
Set cmd = Server.CreateObject("ADODB
Set cmd.ActiveConnection =conn
Const adCmdStoredProc = 4
cmd.CommandText = " sp_GetProduct "
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("PID",
cmd("PID") = 100
cmd.Execute
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
conn.Open "XXX", "XXX", "XXXXXXXX"
Set cmd = Server.CreateObject("ADODB
Set cmd.ActiveConnection =conn
Const adCmdStoredProc = 4
set p = cmd.CreateParameter("PID",
cmd.Parameters.Append p
p.value = 100
cmd.Execute