SPROC Question, what am I doing wrong?

[dj shane]

Here's my SPROC.

CREATE PROCEDURE UpdateHits
AS
DECLARE @Result AS int
DECLARE @ResultDate AS datetime
SET @Result = (SELECT HitCount FROM v2_hit WHERE Hitdate = @ResultDate)

IF @Result <> ''
BEGIN
UPDATE v2_hit
SET HitCount = HitCount + 1
WHERE HitDate = @ResultDate
END
ELSE
BEGIN
INSERT INTO v2_hit
(HitCount, HitDate)
VALUES(1, @ResultDate)
END
GO


And here's how Im calling it.

<cfstoredproc procedure="UpdateHits" datasource="cart">
<cfprocparam type="In" cfsqltype="CF_SQL_DATE" dbvarname="ResultDate"
value="#createODBCDateTime(now())#">
</cfstoredproc>

I don't need any vars back, just trying to pass it a date.

[philh]

Hi Shane,

The error says you're supplying a parameter to an SP that doesn't require one.
It's correct.

Change

CREATE PROCEDURE UpdateHits
AS
DECLARE @Result AS int
DECLARE @ResultDate AS datetime
SET @Result = (SELECT HitCount FROM v2_hit WHERE Hitdate = @ResultDate)

to

CREATE PROCEDURE UpdateHits
@ResultDate datetime
AS
DECLARE @Result AS int

SET @Result = (SELECT HitCount FROM v2_hit WHERE Hitdate = @ResultDate)

Params have to be declared before the AS word.

HTH,

[dj shane]

I knew it was something simple, thanks a million