Re: Re: Calling MSSQL Stored Procedure
| From: | Alf Stockton | Date: | Tue, 20 Sep 2005 15:11:18 +0000 |
| Subject: | Re: Re: Calling MSSQL Stored Procedure | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-26370@lists.php.net to get a copy of this message | ||
Robert Twitty wrote:
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,I added the following to my code but still no success. // $ActualDate = time(); // $ActualDate = date('Y-m-d H:i:s', time()); $ActualDate = strtotime("2005/05/16 06:00:00"); echo $ActualDate; and I still get nothing back not even the echo $ActualDate ? BTW The date string above is/was copied directly out of the database. -- Regards, Alf Stockton www.stockton.co.za Q: "What is the burning question on the mind of every dyslexic existentialist?" A: "Is there a dog?" My email disclaimer is available at www.stockton.co.za/disclaimer.html