Justtechjobs.com Find a programming school near you






Online Campus Both


php-developer-list | 2001041

[PHP-DEV] RE: PHP 4.0 Bug #9284 Updated: odbc_execute , SQL state 07001 in SQLExecute From: moisey.g.oysgelt <email protected>
Date: 04/02/01

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:php-dev <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: moisey.g.oysgelt <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] moisey.g.oysgelt <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: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>