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

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@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 >---------------------------------------------------------------------- ******************************************************************** 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@lists.php.net For help: php-dev-help@lists.php.net