note 88295 added to function.odbc-setoption
| From: | egil at wp dot pl | Date: | Mon, 19 Jan 2009 15:42:22 +0000 |
| Subject: | note 88295 added to function.odbc-setoption | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-149446@lists.php.net to get a copy of this message | ||
Some options for Microsoft SQL Server ODBC:
1 - (SQL_MAX_ROWS) show top x rows
6 - (SQL_CURSOR_TYPE) zmiana kursora - ma dziaÅaÄ dopiero w PHP 5.3
You can "translate" constant names (found on e.g. Microsoft website) to appropriate values
using this page:
http://www.freepascal.org/docs-html/packages/odbcsql/index-2.html
BTW. If anyone is banging his head about "cursor type changed" warning while using execute
with ORDER BY clause, then just use exec for now (remember to addslashes for yourself). In PHP 5.3 a
Bug #43668 will be fixed and it will allow you to change a cursor type to SQL_CUR_USE_ODBC.
Note that you could also try to select a cursor type in odbc_connect, but that didn't work for
me (much more problems appeared then it solved).
----
Server IP: 82.177.164.100
Probable Submitter: 83.15.121.158
----
Manual Page -- http://www.php.net/manual/en/function.odbc-setoption.php
Edit -- https://master.php.net/note/edit/88295
Del: integrated -- https://master.php.net/note/delete/88295/integrated
Del: useless -- https://master.php.net/note/delete/88295/useless
Del: bad code -- https://master.php.net/note/delete/88295/bad+code
Del: spam -- https://master.php.net/note/delete/88295/spam
Del: non-english -- https://master.php.net/note/delete/88295/non-english
Del: in docs -- https://master.php.net/note/delete/88295/in+docs
Del: other reasons-- https://master.php.net/note/delete/88295
Reject -- https://master.php.net/note/reject/88295
Search -- https://master.php.net/manage/user-notes.php