Bug #7274 Updated: odbc_execute does not accept new arguments when failing

ID: 7274 User Update by: edrenth@thematec.nl Status: Closed Bug Type: ODBC related Operating system: redhat 6.2 linux 2.2.16-3 PHP Version: 4.0.3 Description: odbc_execute does not accept new arguments when failing OK, I'll have to live with this bug, since this version of the unify database is obsolete and openlink does not update or support their drivers for it anymore. Eduard Previous Comments: --------------------------------------------------------------------------- [2001-05-07 23:17:02] kalowsky@php.net Openlink does not support the UNIFY database. If you wish to persue this issue, please open a support case with the openlink software people at http://www.openlinksw.com/support/suppindx.htm --------------------------------------------------------------------------- [2001-05-07 21:50:22] kalowsky@php.net A) have you tried PHP 4.0.5? B) have you tried updating to the latest OpenLink (4??) drivers? --------------------------------------------------------------------------- [2001-04-19 07:05:46] edrenth@thematec.nl RESUBMITTED IN ENGLISH, STILL OCCURS IN 4.04PL1 I am working with openlink drivers for a UNIFY 2000 database No recent drivers available So, here's a testscript: <?php // first make your connection with odbc_connect() if (odbc_exec($conn,"create table test (veld char (1))")) odbc_commit($conn); else die("Fail to Create Table"); $st=odbc_prepare($conn,"insert into test values (?)"); $arg[0]="aa"; // statement will fail if (odbc_execute($st,$arg)) odbc_commit($conn); else { $arg[0]="b"; if (odbc_execute($st,$arg)) // statement fails again odbc_commit($conn); else { print "again fail to insert"; exit; } } $res=odbc_exec($conn,"select * from test"); odbc_result_all($res); if (odbc_exec($conn,"drop table test")) odbc_commit($conn); else print "Failed to drop"; ?> --------------------------------------------------------------------------- [2001-04-16 22:30:32] kalowsky@php.net please re-submit report in english... also does this still occur in the latest releases of PHP? --------------------------------------------------------------------------- [2000-10-17 07:25:31] edrenth@thematec.nl $st=odbc_prepare($conn,"update tabel set veld1=?"); $arg[0]="1"; odbc_execute($st,$arg); // stel dat dit statement mislukt $arg[0]="3"; odbc_execute($st,$arg); // nu zal odbc_execute weer "1" als waarde van het argument gebruiken. ./configure --with-mysql=no --with-openlink --with-apache=../apache_1.3.12 --enable-track-vars --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. Full Bug description available at: http://bugs.php.net/?id=7274