[PHP-WIN] Calling MSSQL Stored Procedure

2005-09-15 Thread 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 Promoti

Re: [PHP-WIN] Calling MSSQL Stored Procedure

2005-09-15 Thread Robert Twitty
On Thu, 15 Sep 2005, Alf Stockton wrote: > Thanks for the suggestions on ADODB which, thanks to you, I have > implemented. > > I like the simularity between databases as my applications are going to > be accessing both MSSQL & Oracle. > > The next step is for me to use ADODB & PHP to call vari

[PHP-WIN] Calling MSSQL Stored Procedure

2005-09-15 Thread Alf Stockton
Thanks for the suggestions on ADODB which, thanks to you, I have implemented. I like the simularity between databases as my applications are going to be accessing both MSSQL & Oracle. The next step is for me to use ADODB & PHP to call various MSSQL and Oracle Stored Procedurers so I am curre