Hi,
The following is my SQL Server Stored procedure:
The following is the ASP code that I am trying to execute, but in vain.
I have ensured that none of the input parameters are blank or left out.
Why am I getting the following error ?
This error makes me sick, and I very badly need your assistance. Thank you...
RR
The following is my SQL Server Stored procedure:
Code:
CREATE PROCEDURE [Proc_insert]
(@UPI_1 [int],
@DateFrom_2 [char](12),
@DateTo_3 [char](12),
@locationID_4 [int],
@Status_5 [char](15))
AS INSERT INTO [GSD_Test].[dbo].[SUSPENDED_PARKING]
( [UPI],
[DateFrom],
[DateTo],
[locationID],
[Status])
VALUES
( @UPI_1,
CAST(@DateFrom_2 AS DATETIME),
CAST(@DateTo_3 AS DATETIME),
@locationID_4,
@Status_5)
The following is the ASP code that I am trying to execute, but in vain.
Code:
Dim cmd
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = cn
' Define the stored procedure's inputs and outputs
' Question marks act as placeholders for each parameter for the
' stored procedure
cmd.CommandType = 4 'adCmdStoredProc
cmd.CommandText = "{call Proc_Insert_Suspended_parking(?,?,?,?,?)}"
' specify parameter info 1 by 1 in the order of the question marks
' specified when we defined the stored procedure
'cmd.Parameters.Append cmd.CreateParameter("RetVal", adInteger, adParamReturnValue)
cmd.Parameters.Append cmd.CreateParameter( "UPI", adInteger, adParamInput)
cmd.Parameters.Append cmd.CreateParameter("DateFrom", adVarChar , adParamInput,12)
cmd.Parameters.Append cmd.CreateParameter("DateTo", adVarChar , adParamInput,12)
cmd.Parameters.Append cmd.CreateParameter("LocationID", adInteger, adParamInput)
cmd.Parameters.Append cmd.CreateParameter("Status", adChar, adParamInput,15)
cmd.Parameters("UPI").Value = Request.Cookies("UPI")
cmd.Parameters("DateTo").Value = "'" & cdate(Request.Form("txtToDate")) & "'"
cmd.Parameters("DateFrom").Value= "'" & CDate(Request.Form("FromMon") & "/" & Request.Form("FromYear")) & "'"
cmd.Parameters("LocationID").Value = Request.Form("selLocation")
cmd.Parameters("Status").Value = "Suspended"
Response.Write "<HR>"& cmd.Parameters(0).Name & "*" & cmd.Parameters(0).Value & "<BR>"
Response.Write cmd.Parameters(1).Name & "*" & cmd.Parameters(1).Value & "<BR>"
Response.Write cmd.Parameters(2).Name & "*" & cmd.Parameters(2).Value & "<BR>"
Response.Write cmd.Parameters(3).Name & "*" & cmd.Parameters(3).Value & "<BR>"
Response.Write cmd.Parameters(4).Name & "*" & cmd.Parameters(4).Value & "<HR>"
'Response.Write cmd.Properties.length
cmd.Execute
Response.Write "<HR>" & err.Description & "<HR>"
I have ensured that none of the input parameters are blank or left out.
Why am I getting the following error ?
Code:
No value given for one or more required parameters
This error makes me sick, and I very badly need your assistance. Thank you...
RR