|  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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: philip at qs dot co dot nz
New email:
PHP Version: OS:


 [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-2023 The PHP Group
All rights reserved.
Last updated: Sun Sep 24 16:01:24 2023 UTC