Re: odbc_exec and error handling in transact sql

Hallo Renze, Bedankt voor je reactie. The problem is that the stored procedure in the odbc_exec didn't went wrong. It encountered an error, handled it and finished the final part of the code successfully. Unfortunately, the odbc_exec returns false. The stored procedure has an output parameter who's value i have the use in the remainder of the php code, but i can not get it through odbc_result because of the false return value. "Renze Munnik" <renze@datalink.nl> wrote in message news:3ACC8967.47E1C0E5@datalink.nl... > 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 > *************************** > > -- > 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 >