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

[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->fields);
       $rs->MoveNext();
   }

Hello Bob,

BTW I have attempted both dates with the same result.


--

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

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. I have also checked and yes the ODBTP server is running as an Apache service.

reg2.php
Description: application/php

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php