php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #19373 conn.execute($sqlstm) failed for add, update and delete in microsoft access 97
Submitted: 2002-09-12 06:54 UTC Modified: 2002-11-02 01:00 UTC
Votes:2
Avg. Score:4.5 ± 0.5
Reproduced:0 of 0 (0.0%)
From: jimsonchang at yahoo dot com Assigned:
Status: No Feedback Package: COM related
PHP Version: 4.2.3 OS: Windows 2000
Private report: No CVE-ID: None
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: jimsonchang at yahoo dot com
New email:
PHP Version: OS:

 

 [2002-09-12 06:54 UTC] jimsonchang at yahoo dot com
like summary,

conn.execute($sqlstm) failed for adding, updating and deleting sqlstament against microsoft access (ver. 97) i haven't try it in office access 2000.

my test
======
i get two computer(A and B), with same php.ini file,
using the same php script.

comp A is installled with php 4.2.2 while comp B is installed with php 4.2.3

after setup, i run the script, comp A can execute the sql statement i gave without problem... while comp B can only
perform sql statement (SELECT * FROM TABLENAME)
UPDATE, INSERT INTO and DELETE failed for comp B which is using php 4.2.3

i post the following problem already in the php forum
please go there to get the script i test.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10209715


sincerely,
Jimson Chang

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-10-02 07:21 UTC] phanto@php.net
do you get any error messages ?
 [2002-10-02 19:11 UTC] jimsonchang at yahoo dot com
no error message, it just won't execute
the sql statement for add, update and delete.
"select" sql statement is ok.
 [2002-10-17 11:26 UTC] phanto@php.net
pease try a recent version from snaps.php.net
 [2002-10-17 12:32 UTC] sniper@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip


 [2002-11-02 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over 2 weeks, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Dec 30 15:01:28 2024 UTC