Re: odbc_exec and error handling in transact sql
| From: | Renze Munnik | Date: | Thu, 05 Apr 2001 15:04:07 +0000 |
| Subject: | Re: odbc_exec and error handling in transact sql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8274@lists.php.net to get a copy of this message | ||
Ilse wrote:
>
> Hello,
>
> I have a problem with odbc_exec in combination with error handling in my
> stored procedure on sql server7.
>
> When an error in the stored procedure occurs, the procedure finishes with no
> problems but the return value of the odbc_exec function is false. The
> problem with this false return value is that i, because of that, not the
> output parameter of the stored procedure can access through odbc_result.
>
> Does anybody know a sollution?
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
Uhm. Don't you check the result of odbc_exec() then? I mean, if you
know that that function went wrong; isn't that enough to know what
to do (or what _not_ to do)?
I don't realy see the problem here. What's the big diff if odbc_exec
tells you it went wrong or that odbc_result tells you it went
wrong???
--
* R&zE:
***************************
** Renze Munnik
**
** E: renze@datalink.nl
** M: +31 6 218 111 43
***************************