Re: Re: Calling MSSQL Stored Procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Attachment: reg2.php
Description: application/php

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

[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux