Bug #9284 Updated: odbc_execute , SQL state 07001 in SQLExecute

ID: 9284 Updated by: kalowsky@php.net Reported By: moisey.g.oysgelt@mail.sprint.com -Status: Duplicate +Status: Closed Bug Type: ODBC related Operating System: Windows NT 4 SP 5 PHP Version: 4.0.2 Previous Comments: ------------------------------------------------------------------------ [2001-04-16 23:21:09] 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 :\ ------------------------------------------------------------------------ [2001-04-03 08:51:01] 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-02 17:01:06] kalowsky@php.net you checked this without parameter? which parameter? ------------------------------------------------------------------------ [2001-02-15 12:48:08] moisey.g.oysgelt@mail.sprint.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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=9284&edit=1