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

go to bug id or search bugs for

Bug #9548 Duplicate record inserts using ODBC
Submitted: 2001-03-04 13:23 UTC Modified: 2001-05-11 15:08 UTC
From: arnoldg at allegheny dot edu Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.4pl1 OS: Windows 98 SE
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: arnoldg at allegheny dot edu
New email:
PHP Version: OS:

 

 [2001-03-04 13:23 UTC] arnoldg at allegheny dot edu 
When using MySQL 3.23.32 (stable release), MyODBC 2.50.36, and PHP 4.0.4pl1 on Windows 98, using the odbc_prepare() and odbc_execute() function combination to insert a row into a table results in duplicate entries in the table.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-03-05 10:17 UTC] arnoldg at allegheny dot edu 
A sample insert statement is as follows:

insert into tble(tble_nme) values('my_value');

The record is inserted into the table correctly, except for the fact that it appears twice.

Calls to the hybrid function odbc_exec() result in an exception, leading me to believe that it is unsupported by the MySQL ODBC driver.

The same code works correctly when connecting to a Sybase SQL Anywhere 7.0 database via ODBC, so I do not believe that it is a code flaw.
 [2001-05-11 15:08 UTC] kalowsky@php.net 
if you don't believe it's a flaw, the bug is closed.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 11:01:30 2025 UTC