PHP-ODBC-MSSQL (Text type fields)
| From: | Michael Yevdokimov | Date: | Tue, 10 Jul 2001 21:34:38 +0000 |
| Subject: | PHP-ODBC-MSSQL (Text type fields) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10233@lists.php.net to get a copy of this message | ||
Hello
Did anybody have problems with retrieving data from the fields of type
Text..
<?php
$dsn = "dsn_database";
$user = "enduser";
$pass = "";
$query = "usp_get_subj 10";
$conn = odbc_connect($dsn, $user, $pass);
$res = odbc_exec($conn, $query);
while (odbc_fetch_row($res)) {
//$data = odbc_field_type($res, 10); // text
//$data = odbc_field_name($res, 10); // col_subj_content
//$data = odbc_field_len($res, 10); // 2147483647
$data = odbc_result($res, "col_subj_content");
//$data = odbc_result($res, 10);
echo $data;
}
odbc_close($conn);
?>
I can retrieve any other fields but not the field of type text.. What could
be the problem?
Thank you.
Mike
Michael Yevdokimov
Web developer
e-mail: michaely@globalocity.com
--------------------------------
Globalocity B.V.
Tel.: +31 (0)70 312 2814
Fax.: +31 (0)70 312 2808
http://www.globalocity.com
e-mail: info@globalocity.com
--------------------------------