Re: Re: Calling MSSQL Stored Procedure

The code will generate a blank screen if there are no reesults returned by the stored procedure. Have you verified that the query performed by the stored procedure will generate a result set for the current time? To verify this, use strtotime( "YYYY-MM-DD HH:MM:SS" ) instead of time(). Make sure you call strtotime() with a date / time that you know will generate a result set. -- bob On Tue, 20 Sep 2005, Alf Stockton wrote: > 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 > >