Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001072

[PHP-DB] PHP informix function ifx_error problem From: Andrey V. Glukhov (andrey <email protected>)
Date: 07/27/01

when I trying to execute the following php code:
<?
$connid=ifx_connect("basename","username","password" );

$q="execute procedure test()";
$i=ifx_query($q,$connid);
echo( ifx_errormsg() );

ifx_free_result($i);
?>

and stored procedure is:
CREATE PROCEDURE TEST()
   RAISE EXCEPTION -746, 0, "testing...";
END PROCEDURE

I expect to see "testting..." but see nothing :-(
After some debuging I found out that while sqlca.sqlcode is equal -746,
sqlca.sqlerrm is empty.
I suppose it is informix/php interface bug because correspondent esqlc code
works with sqlca structure fine,
but I am not php or esqlc developer to patch php source :-(

Is there a way to send the message by stored pocedure exception to php?

Best wishes
Andrey Glukhov 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>