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

Reply via email to