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

go to bug id or search bugs for

Bug #9284 odbc_execute , SQL state 07001 in SQLExecute
Submitted: 2001-02-15 12:48 UTC Modified: 2002-05-21 23:40 UTC
From: moisey dot g dot oysgelt at mail dot sprint dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.2 OS: Windows NT 4 SP 5
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: moisey dot g dot oysgelt at mail dot sprint dot com
New email:
PHP Version: OS:

 

 [2001-02-15 12:48 UTC] moisey dot g dot oysgelt at mail dot sprint dot com 
I tried to use this function with Microsoft Access Driver

 $values = array( $ApplicantId ,$AnsQuestionId[$i],$Answer[$i]);
$query = "INSERT INTO Responses ([PersonId], [QuestionId], [Response], [Date]) ";
$query .= "VALUES(?,?,?," . strftime("#%Y-%m-%d#") .") ";
$result = odbc_prepare($connection, $query);
odbc_execute($result, $values );
 and got error 
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect , SQL state 07001 in SQLExecute in D:/Xitami/webpages/moveit/index.php on line 46
 I've checked without  parameter. The statement worked fine.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-04-02 17:01 UTC] kalowsky@php.net 
you checked this without parameter?  which parameter?
 [2001-04-03 08:51 UTC] kalowsky@php.net 
user reports:


I've tried the same without bind variables  ('?')[parameters]  the
statement worked ok.
If I tried to bind variables into  an array this did not work for me for
ODBC with MS Access, the same worked with Oracle.

Thanks for help
 [2001-04-16 23:21 UTC] kalowsky@php.net 
This sounds similar now to bug 6275, where it seems that MSAccess cannot handle the ? operator.  I could be wrong, but so far that is what all my initial research has pointed to.  Unless you can prove otherwise i'm going to mark this as a duplicate bug, and hopefully find out if MSAccess can do this ... soon :\
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jan 15 13:01:29 2025 UTC