Simple SP Error passing Date to SP 1

[JordanR]

I get the following error when trying to pass a date to a stored procedure:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '/'.

/testing/storedproc2.asp, line 16

My call to the procedure is:

getdate = "06/09/2006"
SET rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Exec getexpiring " & getdate, con
response.write rs("domain_sld")

my stored procedure is:

CREATE proc getexpiring
@thedate datetime
AS
SELECT * FROM mytable WHERE expireationdate <= @thedate
GO


Can anyone help me with this?

 

[Gorkem]

Try using the following:

rs.Open "Exec getexpiring @thedate='" & getdate & "'", con

GT Interactive

http://www.gt-interactive.net

-----------------------------
Components/Tools/Forums/Software/Web Services

 

[JordanR]

That makes a whole lot of sense, to put double quotes there.
Thanks alot. It worked.

 

[JordanR]

Gorkem,
I am a newbie at sp,
can you direct me to a place where I can learn more about SP with ASP? Some place where rocket scientist aren't teaching?

 

[Gorkem]

Well there really isn't much to learn about using SP with ASP..

HOWEVER...

What you will want to read up on is ADODB.Command and using the PARAMETERS function.. once you understand how to use this, SP's are a snap! ;o)

Cheers,

G.

P.S.

Thanks for the star!



GT Interactive

http://www.gt-interactive.net

-----------------------------
Components/Tools/Forums/Software/Web Services

 

[JordanR]

Thanks a million!
Jordan