note 107782 added to function.odbc-result
| From: | BunakovM at meta dot ua | Date: | Sun, 04 Mar 2012 13:28:44 +0000 |
| Subject: | note 107782 added to function.odbc-result | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-186486@lists.php.net to get a copy of this message | ||
About memo MS Access
for get data from memo field of MS Access correctly i add SQL_CUR_USE_ODBC parametr in odbc_connect.
and with this parametr I don't use odbc_longreadlen and odbc_binmode.
<?php
$odbc_conn_id = odbc_connect($odbcConn['dsn'], "", "",
SQL_CUR_USE_ODBC) or die("Couldn't connect to datasource.");
$odbc_query = "SELECT * FROM " . $table_name;
$odbc_res = odbc_exec($odbc_conn_id, $odbc_query);
odbc_longreadlen($odbc_res, 1024*1024);
$temp = odbc_result($odbc_res, 'memo_filed');
echo "memo_filed : " . $temp;
?>
----
Server IP: 69.147.83.197
Probable Submitter: 91.209.51.176
----
Manual Page -- http://www.php.net/manual/en/function.odbc-result.php
Edit -- https://master.php.net/note/edit/107782
Del: integrated -- https://master.php.net/note/delete/107782/integrated
Del: useless -- https://master.php.net/note/delete/107782/useless
Del: bad code -- https://master.php.net/note/delete/107782/bad+code
Del: spam -- https://master.php.net/note/delete/107782/spam
Del: non-english -- https://master.php.net/note/delete/107782/non-english
Del: in docs -- https://master.php.net/note/delete/107782/in+docs
Del: other reasons-- https://master.php.net/note/delete/107782
Reject -- https://master.php.net/note/reject/107782
Search -- https://master.php.net/manage/user-notes.php