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 Add Comment Developer Edit
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Sat Apr 20 02:01:29 2024 UTC