php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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-2024 The PHP Group
All rights reserved.
Last updated: Wed Oct 30 22:01:28 2024 UTC