PHP 4.0 Bug #9284: odbc_execute , SQL state 07001 in SQLExecute
| From: | moisey dot g dot oysgelt at mail dot sprint dot com | Date: | Thu, 15 Feb 2001 17:48:08 +0000 |
| Subject: | PHP 4.0 Bug #9284: odbc_execute , SQL state 07001 in SQLExecute | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-46676@lists.php.net to get a copy of this message | ||
From: moisey.g.oysgelt@mail.sprint.com
Operating system: Windows NT 4 SP 5
PHP version: 4.0.2
PHP Bug Type: ODBC related
Bug description: odbc_execute , SQL state 07001 in SQLExecute
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 Bug report at: http://bugs.php.net/?id=9284&edit=1