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
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
