Re: [PHP-DEV] Bug #1039 Updated: odbc_fetch_into( ) doesn't ignore the rownumber parameter if it is not supporte From: Cameron Just (ccjust <email protected>)
Date: 02/16/99

Thankyou very much that fixed the problem.
I have setup a page which shows all types of cursor settings.

http://void.cc.uq.edu.au/php/PHP3ODBC/phpbugtest.php3

It does some weird things still but the sequence of commands I test with
are weird and would probably never be used in real life.
Using SQL_CUR_USE_ODBC causes each of the functions to behave as expected.

Thanks again.

At 15:09 16/02/1999 -0800, you wrote:
>On 16 Feb 99, at 15:05, Bug Database wrote:
>
>> ID: 1039
>> Updated by: kara
>> Reported By: ccjust <email protected>
>> Status: Closed
>> Bug Type: ODBC related
>>
>> AFAIK the Windows ODBC DriverManager has a cursor library, so even
>> drivers that don't support absolute fetches (rownumbers) would work
>> with the rownumber parameter. Probably, the use of this cursor library
>> can be switched on and off, but don't ask me where ;-)
>>
>> Full Bug description available at: http://ca.php.net/bugs.php3?id=1039
>
>>From the bug description:
>
>> Find a way to have the rownumber working with ODBC and
>> MSSQL 6.5 (I would try if I had the slightest idea where to start
>> and knew how to compile a Win32 binary. :) )
>
>It might not take that much work. As of 3.0.6, the syntax for
>odbc_connect() is:
>
>odbc_connect(string dsn, string user, string password, int
>cursor_type);
>
>where cursor_type can be one of:
>
>SQL_CUR_USE_IF_NEEDED
>SQL_CUR_USE_ODBC
>SQL_CUR_USE_DRIVER
>
>I haven't tested it for your particular problem, but it's possible that
>one of these, maybe SQL_CUR_USE_ODBC, could do what you
>need.
>
>Please let me know if this does the trick.
>
>Dave
>
>
>----------------------------------------------------------------------
>Dave Walton
>Webmaster, Postmaster Emusic
>walton <email protected> http://www.emusic.com
>----------------------------------------------------------------------

********************************************************************
Cameron Just
Web Development ( Information Technology Services )
University of Queensland
Ph 3365 7412
******************************************************************** 

--
PHP Development Mailing List   http://www.php.net/
To unsubscribe send an empty message to php-dev-unsubscribe <email protected>
For help: php-dev-help <email protected>