[PHP-WIN] Calling MSSQL Stored Procedure

[Alf Stockton]

I have to access a MsSQL stored procedure coded as follows :-
CREATE PROCEDURE spGetActivePromotions
  @Today datetime
AS
SELECT PromotionID, PromotionName, StartDate, EndDate, LastDrawDate,
      MaxDraws, NumRegTickets, VouchersPermitted, NumTicketsPerVoucher, 
ManualTicketIssue
  FROM Promotion
  WHERE @Today>=StartDate AND @Today<=EndDate
GO

and therefore have coded my php as follows :-

   $PMdriver = "mssql";
   $PMdb = ADONewConnection($PMdriver);
   $PMdb->Connect($PMserver, $PMuser, $PMpassword, $PMdatabase);
   $SQL = $PMdb->Prepare("spGetActivePromotions");
   $ActualDate = strftime("%Y/%m/%d %I:%m:%S %p");
   $PMdb->InParameter($SQL, $ActualDate, "Today");
   $PMdb->OutParameter($SQL, $ret, 'RETVAL');

but I keep getting the error message
201: Procedure 'spGetActivePromotions' expects parameter '@Today', which 
was not supplied.

Please tell me how I got this wrong.

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php