|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #486 ODBC odbc_result_into & CURSOR_DYNAMIC
Submitted: 1998-06-26 21:03 UTC Modified: 1998-06-29 09:32 UTC
From: philip at qs dot co dot nz Assigned:
Status: Closed Package: Feature/Change Request
PHP Version: 3.0 Final Release OS: Linux Elf-i586
Private report: No CVE-ID: None
 [1998-06-26 21:03 UTC] philip at qs dot co dot nz
After upgrading iODBC driver , mysql_odbc driver , and
php 3.0 under linux there has been a change in functionality
regarding odbc_result_into.

The unified odbc driver now expects all iODBC drivers to have extended fetch
capability. As the mysql_odbc driver only supports STATIC cursors
the unified_odbc.c code now aborts the execute command because the
cursor type dynamic cannot be set.
Changing the compile to default to no extended fetch works around
this problem but now requires one less parameter on the
odbc_result_into call.

Requested Changes:

	1. For odbc_fetch_into takes three arguments. Record number is 
	ignored if no extended_fetch. This allows portability of code.

	2. For unified_odbc:PHP3_UODBC_DO code passively ignores failed request to set
	dynamic cursors and functions if extended fetch not avaliable. 

 Although mysql only support static cursors it does allow referencing
 rows within the data set returned.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [1998-06-29 09:32 UTC] kara
This is a bug in the mysql ODBC driver. The driver should return
SQL_SUCCESS_WITH_INFO and substitute an appropriate cursor type.
Myodbc instead returns SQL_ERROR and substitutes the cursor type. 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Jul 23 22:01:28 2024 UTC