Re: Re: Calling MSSQL Stored Procedure

[Alf Stockton <alf@xxxxxxxxxxxxxx>]

Mark Rees wrote:

> > 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");
> >    
>
> what does echo $ActualDate give you?
>
>  
I get 2005/09/16 10:09:22 AM which is exactly the same format as it 
appears in the database table when viewed via Enterprise Manager.

--

Regards,
Alf Stockton		www.stockton.co.za

Today is what happened to yesterday.

My email disclaimer is available at www.stockton.co.za/disclaimer.html

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