PHP, Sybase, Stored Procedures
| From: | Walter, Marcel | Date: | Fri, 04 Oct 2002 08:11:57 +0000 |
| Subject: | PHP, Sybase, Stored Procedures | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22215@lists.php.net to get a copy of this message | ||
Hello world,
I´ve got a problem concerning PHP, Sybase and Stored Procedures....
I want to execute a stored proc from sybase called "sp_helprotect" ... this
proc is directly from
sybase so I don´t want to change it ... When I look at the proc I see that
"nocount" is set on...
This means that a query won´t be able to determine how much rows were
affected/returned.
I cannot read the resultset from this query!!! (within PHP)
I created an exact copy of sp_helprotect without "set nocount on" and then
it worked fine!
(resultset could be read)
Is there a workaround or does anyone have a solution to this problem ???
Looking forward to all answers ...
Regards,
Marcel
----------------------------------------------------------------------
If you have received this e-mail in error or wish to read our e-mail
disclaimer statement and monitoring policy, please refer to
http://www.drkw.com/disc/email/ or contact the sender.
----------------------------------------------------------------------