php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #7274 odbc_execute does not accept new arguments when failing
Submitted: 2000-10-17 07:25 UTC Modified: 2001-05-09 06:20 UTC
From: edrenth at thematec dot nl Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.3 OS: redhat 6.2 linux 2.2.16-3
Private report: No CVE-ID: None
View Developer Edit
 [2000-10-17 07:25 UTC] edrenth at thematec dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-16 22:30 UTC] kalowsky@php.net 
please re-submit report in english...

also does this still occur in the latest releases of PHP?
 [2001-04-19 07:05 UTC] edrenth at thematec dot 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-05-07 21:50 UTC] kalowsky@php.net 
A) have you tried PHP 4.0.5?
B) have you tried updating to the latest OpenLink (4??) drivers?
 [2001-05-07 23:17 UTC] 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-09 06:20 UTC] edrenth at thematec dot nl 
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
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed May 07 04:01:27 2025 UTC