Passing Date to a Stored Proc from an ASP page

[Lftsk]

I hope someone can help me. I'm trying to pass a date range (from and to) from 2 text boxes on an ASP page to a stored procedure bu the recordset keeps coming back empty
when I know there is at least one record in there. I'm using the ADO command object as follows:


FromDate = CDate(trim(Request.Form("txtFrom_Date&quot))
ToDate = CDate(trim(Request.Form("txtTo_Date&quot))

'From Date

Set objParam = cmdInvoice.CreateParameter("@FromDate&quot
objParam.Type = adDBDate
objParam.Direction = adParamInput
objParam.Size = 10
objParam.Value = FromDate
cmdInvoice.Parameters.append objParam
Set objParam = Nothing


'To Date

Set objParam = cmdInvoice.CreateParameter("@ToDate&quot
objParam.Type = adDBDate
objParam.Direction = adParamInput
objParam.Size = 10
objParam.Value = ToDate
cmdInvoice.Parameters.append objParam
Set objParam = Nothing


With cmdInvoice

.ActiveConnection = Conn
.CommandType = adCmdStoredProc
.CommandText = "sp_GetInvoiceList"

End With


Set rstInvoice = cmdInvoice.Execute(numrecs)

The 2 parameters in the Stored Proc are DateTime Datatypes

If anybody can see why this is not working I would greatly appreciate it

 

[mwolf00]

why not just do this

Set rstInvoice = conn.execute("EXEC cmdInvoice '" & request("txtFromDate&quot & "','" & request("txtToDate&quot & "'&quot

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)