ID: 9284
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
you checked this without parameter? which parameter?
------------------------------------------------------------------------
[2001-02-15 12:48:08] [EMAIL PROTECTED]
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
