Re: Re: Calling MSSQL Stored Procedure
| From: | Robert Twitty | Date: | Tue, 20 Sep 2005 15:56:49 +0000 |
| Subject: | Re: Re: Calling MSSQL Stored Procedure | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-26369@lists.php.net to get a copy of this message | ||
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 ) {
print $DB->ErrorMsg();
die;
}
while (!$rs->EOF) {
print_r($rs->fields);
$rs->MoveNext();
}
Also, you should enable ADODb debugging.
-- bob
> 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
>
>