Re: Bug #1039 Updated: odbc_fetch_into( ) doesn't ignore the rownumber parameter if it is not supporte

On 16 Feb 99, at 15:05, Bug Database wrote: > ID: 1039 > Updated by: kara > Reported By: ccjust@prentice.uq.edu.au > 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@emusic.com http://www.emusic.com ---------------------------------------------------------------------- -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net