Re: [PHP-WIN] Re: Calling MSSQL Stored Procedure

2005-09-20 Thread Alf Stockton
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( "-MM-DD HH:MM:SS" ) instead

Re: [PHP-WIN] Re: Calling MSSQL Stored Procedure

2005-09-20 Thread Robert Twitty
IF the "echo $ActualDate" is not displaying, then is it possible that the script is terminating before that statement? Also, to make sure your ODBTP setup is working properly, run the following code after connecting: $rs = $DB->Execute( "SELECT * FROM AnyTable" ); if( !$rs ) { pri

Re: [PHP-WIN] Re: Calling MSSQL Stored Procedure

2005-09-20 Thread Robert Twitty
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( "-MM-DD HH:MM:SS" ) instead of time(). Make sure yo

[PHP-WIN] Zend Safeguard

2005-09-20 Thread Joakim Ling
Hi Does Zend Safeguard Suite 3.6 works with PHP 5? Cheers

RE: [PHP-WIN] FW: MySQL Problem

2005-09-20 Thread Vincent Kruger
Hey all, Thanks for the help, but it's all seemed to start work the next day. Sorry all about the double post, that was my bad. :D V -Original Message- From: Vincent Kruger [mailto:[EMAIL PROTECTED] Sent: 19 September 2005 04:46 PM To: php-windows@lists.php.net Subject: [PHP-WIN] FW: M

Re: [PHP-WIN] Re: Calling MSSQL Stored Procedure

2005-09-20 Thread Alf Stockton
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->field