Re: Re: Calling MSSQL Stored Procedure

Robert Twitty wrote:

Hi Alf Based on a previous posting, the code for the stored procedure spGetActivePromotions does not return a value. Therefore, $ret is going to be undefined. The procedure returns a result set that you must iterate via $rs: while (!$rs->EOF) {

       print_r($rs->fields);
       $rs->MoveNext();

} Hello Bob,

I have tried the above and still I get a blank page back. No data no errors nothing. I have also looked in Apache logs and there is a reference in the access.log but nothing in the error.log. I have attached a copy of my program just in case you can see from that what I have done wrong. BTW I have attempted both dates with the same result. I have also checked and yes the ODBTP server is running as an Apache service. -- Regards, Alf Stockton www.stockton.co.za Q: Why do firemen wear red suspenders? A: To conform with departmental regulations concerning uniform dress. My email disclaimer is available at www.stockton.co.za/disclaimer.html