Subject | RE: [firebird-php] how to capture last exception (from stored procedure) in PHP ? |
---|---|
Author | Darren Thompson |
Post date | 2004-11-08T13:53:54Z |
you have $my_sp->RESULT_VALUE == 0){
}
maybe the result is not always = 0 thats why it is empty maybe it has
another value
-----Original Message-----
From: hamacker [mailto:sirhamacker@...]
Sent: Friday, November 05, 2004 4:30 PM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] how to capture last exception (from stored
procedure) in PHP ?
Hi guys,
I have one store procedure that some part is :
if (:ncount > 0 ) then
begin
EXCEPTION ERROR_SP_GENERIC 'You cant delete existing tickets
dependences';
result_value=0;
suspend;
EXIT;
end
In PHP, the error is OK, but none message.
I try like this :
if ($my_sp->RESULT_VALUE == 0) {
echo "Ops! Error :<br>";
echo ibase_errmsg(); }
But ibase_errmsg() always returning nothing.
There is a solution or workaround for this problem ?
There are some functions in PHP that returning the last warning message?
--
[]'s
Yahoo! Groups Sponsor
Get unlimited calls to
U.S./Canada
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/
b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
}
maybe the result is not always = 0 thats why it is empty maybe it has
another value
-----Original Message-----
From: hamacker [mailto:sirhamacker@...]
Sent: Friday, November 05, 2004 4:30 PM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] how to capture last exception (from stored
procedure) in PHP ?
Hi guys,
I have one store procedure that some part is :
if (:ncount > 0 ) then
begin
EXCEPTION ERROR_SP_GENERIC 'You cant delete existing tickets
dependences';
result_value=0;
suspend;
EXIT;
end
In PHP, the error is OK, but none message.
I try like this :
if ($my_sp->RESULT_VALUE == 0) {
echo "Ops! Error :<br>";
echo ibase_errmsg(); }
But ibase_errmsg() always returning nothing.
There is a solution or workaround for this problem ?
There are some functions in PHP that returning the last warning message?
--
[]'s
Yahoo! Groups Sponsor
Get unlimited calls to
U.S./Canada
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/
b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]