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
Moiswy
-----Original Message-----
From: php-dev [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 5:01 PM
To: moisey.g.oysgelt
Cc: php-dev
Subject: PHP 4.0 Bug #9284 Updated: odbc_execute , SQL state
07001 in SQLExecute
ID: 9284
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
Assigned To:
Comments:
you checked this without parameter? which parameter?
Previous Comments:
------------------------------------------------------------------
---------
[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.
------------------------------------------------------------------
---------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at
http://bugs.php.net/?id=9284&edit=2
<< File: PHP 4.TXT >>
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
